Dashboard widget on PageV2 schema
I have created a simple Dasboard Widget on AccountPageV2 (printscreen from Section Wizard) on Environement 1.
However when i deploy the package, the created dashboard widget doesnt appear in the Environment 2.
I open the section wizard from Environment 2 and the dashboard looks like this:
Form Console I get:
How can I fix this ?
Any update on this issue ?
When dashboards are added to an edit page, the corresponding records are created in SysWidgetDashboard and SysWidgetDashboardLcz tables.
If a dashboard is added not to an edit page but to the "Dashboards" tab, then records will be added in the SysDashboard and SysDashboardLcz tables, respectively.
Also, there is also a corresponding binding of these data to the package which was set as a current package when the dashboards were created.
The thing is that dashboards are localizable system objects. When a dashboard is created, records are created in two tables:
- a record about a dashboard created in the localization, which corresponds to the base culture of the system, is created in the [SysWidgetDashboard]/[SysDashboard] table;
-records about dashboards of all other localizations are created in the [SysWidgetDashboardLcz]/[SysDashboardLcz] table and are linked to a record in the [SysWidgetDashboard]/[SysDashboard] table by the [RecordId] column.
So basically, all you need to do is to prepare a package which will contain all the needed data bindings and SQL scenarios which will perform the records' entry to the tables mentioned above.
More information on data binding is on our academy.
Also, knowledge of SQL might be needed in order to find the needed dashboard in the database, although you can always create a lookup and search via UI.