Please enable JS

Review Recently Modified Diagram in Prolaborate

April 26, 2022

Context

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.

Create a Profile for Reuse

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.

Enable ‘Diagram name’ clickable

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 Profile on a Reports Widget

Apply the profile to a widget to display the result.

Add Reports Widget

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

Choose a Profile or Write a Query

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.

View the recently modified diagrams

Please find below the dashboard screenshot showing the recently modified diagrams report.