In this UMLO EXTRA session, we are going to show how to inject Custom SQL Queries into our Custom Sparx EA Reports. This can be any SQL Query for any Custom Report. You can use this SQL for Model Views and/or Reports.
For Sparx Help: https://sparxsystems.com/enterprise_architect_user_guide/16.1/model_publishing/custom_sql_fragments.html
Chapters
0:00 - Intro
0:13 - Our Use Case
0:53 - Add a Model View Element
1:18 - SQL in Model View Element
2:33 - Create Custom Report
4:01 - Create a Report Fragment
4:44 - Add SQL Query to Fragment
6:33 - Insert Fragment in Report Template
6:53 - Test our Report
7:49 - Make changes to Template
11:31 - Run our new SQL Report from anywhere
15:38 - Outro
=-=-=-= UMLO Website =-=-=-=
https://www.trackotc.com/
=-=-=-= UMLO Blog =-=-=-=
https://umloperator.blogspot.com/
#umloperator
