In Prolaborate, users such as reviewers can review diagrams that have been modified recently by their teams via Reports Widget.
Reports Widget is a reporting functionality of Prolaborate. Using this widget, users can fetch data from the model and display them in a table format. The Reports widget can be added to the dashboard for ease of access.
Though the Reports widget can be used in various scenarios, this article will focus on how the recently modified diagrams are reported and how users can view those diagrams by clicking on the name of the diagram on the report.
Users can write a query and save it as a Profile. They can then represent the same result in a different format by reusing the same profile on different types of charts & reports.
To create a profile, click on Menu > Filter Profiles.
On the Filter Profiles page click on Create Profile.
Enter the query and Save the Profile.
The clickable attribute allows the user to view the Properties of a specific attribute, from Properties window upon clicking on the attribute name. Through the Properties window, users can locate the diagram on the repository browser and more.
To enable Name attribute as Clickable attribute, add “ea_guid as classguid” in the query.
Below is the query to list recently created & modified diagrams
Query if you are using the MSSQL server
select top 10 name, ea_guid as classguid, ModifiedDate from t_diagram where ModifiedDate >= DATEADD(day,-7, GETDATE()) order by ModifiedDate desc
select top 10 name as clickable_DiagramName, ea_guid as classguid, ModifiedDate from t_diagram where ModifiedDate >= DATEADD(day,-7, GETDATE()) order by ModifiedDate desc
Query for MySQL server
select name, ea_guid as classguid, ModifiedDate from t_diagram where ModifiedDate BETWEEN CURDATE() - INTERVAL 7 DAY AND CURDATE() order by ModifiedDate desc limit 0, 10
The above query generates reports capturing the top 10 diagrams that have been modified, updated or newly added in the last 7 days. To increase the time, change the day count “7 Day” in MySQL server and “day-7” in MSSQL.
Apply the profile to a widget to display the result.
To add a Reports widget to a new dashboard, click on Create Dashboard > Create New on the Dashboards page
To add an EA widget to an existing dashboard, click on the Edit icon in the dashboard
Click on Add Widget Button > Add New
Choose Reports and click on Add Widget on the landing page
To apply a profile to a Reports Widget, click on Choose Filter Profile from the dropdown under How do you want to build.
The landing page will display all the existing profiles i.e., those that have already been created. Choose the profile to be reused in the Reports Widget.
Note: Instead of choosing Choose Filter Profile (existing profile), user can choose Configure Now and enter the query instantly.