Scripting Freedom UI Dashboards (SysFreedomDashboard) in Creatio 8.3.0
Hello
Creatio 8.3.0 added the dashboard view in section list, thath allows authorized users to create their own dashboard more or less as it was possible in dashboard of Classic UI.
The object that "hosts" the dashboard is SysFreedomDashboard but it's a virtual object and there's not a table with the same name.
What are the tables involved in Freedom UI Dashboards management? How is it possible creating a SQL script to create some Freedom UI dashboards?
Thanks
Regards
Like
If you configure the dashboard in another way, then it will be a scheme in the package, as described earlier (screenshots 1-2).
If you want to configure the dashboard without changing the package, then such a dashboard is saved in the SysUserLevelSchema table and dependents (screenshots 3-4)
Hello,
Thank you for your question regarding Freedom UI Dashboards in Creatio 8.3.0.
To clarify, the object SysFreedomDashboard is indeed a virtual object and does not correspond to a physical database table.
However, the information related to Freedom UI Dashboards is managed using the following physical tables:
- SysDashboard: Stores dashboard-related metadata, including configurations and layout details.
- SysDashboardItem: Contains the configuration of individual dashboard widgets.
- SysDashboardLcz and SysDashboardItemLcz: Responsible for storing localized strings for dashboards and their items.
If you intend to create a SQL script to query or manipulate data, you can use these tables as a starting point. Please bear in mind that manipulating these tables directly is not recommended and should only be done after ensuring no impact on system functionality
If you need further clarification or have specific requirements, please provide additional details, and we would be happy to assist.
Embedding a "Data" element in a package selecting the freedom UI records from SysDashboard and SysDashboardItem is a good solution? The "Lcz" records would be automatically included in Data package element?
Thanks
Hi,
Freedom does not use SysDashboard tables and others.
You can see how the virtual SysFreedomDashboard object works in the SysFreedomDashboardQueryExecutor scheme.
The system does not store dashboard settings in the DB, but collects them from all client schemes that you create through the designer, for example, OrdersAnalyticsDashboard, AccountsAnalyticsDashboard, etc.
Therefore, you do not need to bind anything additionally to the package if you saved your scheme there.
Hello Lytvynchuk Vladyslav,
Valeriia listed those entities to be the ones involved in SysFreedomDashboard virtual object. When you edit or create a new Freedom UI dashboard nothing changes in current packages then the new dashboards seems not stored in client modules but only in some database tables.
There are two ways for creating a Freedom UI dashboard:
- editing a client schema page, then it goes to the current package
- Creating it without editing any pages, then it seems to go only to database tables via SysFreedomDashboard virtual object. This is the method we need to use.
Checking for the tables listed by Valeriia it seems that those tables are really involved in Freedom UI dashboards (they have new records when you create a new freedom ui dashboard).
Were you talking about the "way 1" or the "way 2" to create freedom ui dashboards?
Thanks
If you configure the dashboard in another way, then it will be a scheme in the package, as described earlier (screenshots 1-2).
If you want to configure the dashboard without changing the package, then such a dashboard is saved in the SysUserLevelSchema table and dependents (screenshots 3-4)