How to create a dashboard that includes packages and element properties using the report widget in Prolaborate.

How to create a dashboard that includes packages and element properties using the report widget in Prolaborate.

Description:

Want to create a report widget using a query that contains both elements and package creation date, modification date, status, and other properties, etc.

Solution:

Step 1: Go to Dashboard and create a report widget.


Step 2: Use the Skip to query option then use the below sample query and fetch the result query in the Result Query tab then click the save button. Make sure to disable the MDG-based report option. IF not elements and package properties will be fetched based on the MDG Profile.


Step 3: The Package and element properties will be displayed in the report.



1). To create a report widget that only shows packages and their properties in the report, please use the following sample query:

Shows package name and its properties in a report.

select Name, ea_guid as classguid,  createddate , 'Package' as hide_basetype, 'Package' as hide_stereotype, notes as html_Description from t_package


2). To create a report widget that shows artifact names and properties along with parent package names in the report, please use the following sample query:

Shows the artifact name and its properties along with the parent package name. 

select package.name as PackageName,  tobj.name as Name, tobj.ea_guid as classguid, tobj.createddate as ElementCreatedOn, tobj.Object_type as hide_basetype, tobj.stereotype as hide_stereotype, tobj.note as html_description from t_object tobj  left join t_package package on package.package_id  = tobj.package_id 
where tobj.package_id in ('1', '21','12')

Note:
  • Customers can modify the queries to display properties based on their requirements.
  • The hide_basetype and hide_stereotype columns are mandatory to display the icons of the artifact.
  • The hide_ prefix is used to hide the columns from display in the final output.

Ticket ID: #6939
Subject: Doubt about dashboard and revisions
Department: Prolaborate Support

    • Related Articles

    • Build Card Widget

      Q1. Build EA Reports Prolaborate allows you to generate dynamic reports faster by using information from your EA model. In this guide, we will look at how to build live reports. To know about the dashboard’s general features and how to create it, ...

    • Known Issues - Dashboard

      Filter option unavaliable for all columns Description The customer reported in v3 that we have every column in report widget have filter option but in v4 only one filter option for all tables. Possible Reason This is a feature in v3 but it was ...

    • FAQs - Prolaborate Installation

      Q1:Can you suggest how we may configure Prolaborate using https and port 443. Do you have any links to documentation? Answer You can configure the Protocol and Port settings from Prolaborate Management typically located in C:\Program ...

    • FAQ's - Reports

      Q1: How to enable sorting in a custom query-based report in Prolaborate? Answer Disable the MDG Based Report toggle in the report widget to enable sorting in custom query-based reports in Prolaborate. Q2: I'm experiencing issues with downloading my ...

    • Known Issues - Adding Elements in Prolaborate

      Q1. Adding a new element with Custom Properties does not include the Properties in EA Description The elements added in Prolaborate have custom properties in them, but they are not included as a tagged value in the model when viewing from Enterprise ...