Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: aguevara on June 24, 2014, 04:00:12 am

Title: How to determine the number of activity diagrams
Post by: aguevara on June 24, 2014, 04:00:12 am

All,
I am trying to determine the number of activity diagrams in my EA model.

Is there a script or an easy way of doing so?

I would also like to see if I can get a script to count how many "action" are in the model.

Thanks,
Angelo
[email protected]

Title: Re: How to determine the number of activity diagra
Post by: qwerty on June 24, 2014, 05:40:54 am

Ctrl-F
Builder
SQL

Code: [Select]

select count(*) from t_diagram where diagram_type = "Activity"Run

q.

Title: Re: How to determine the number of activity diagra
Post by: Eve on June 24, 2014, 09:42:31 am

Also look at the Project Statistics page from Project | Project Status.

Title: Re: How to determine the number of activity diagra
Post by: Geert Bellekens on June 24, 2014, 03:57:10 pm

To count actions you do

Code: [Select]

select count(*) from t_object where Object_Type = 'Action'
Geert

PS. You'll probably need to use single quotes in the query from qwerty as well.

Title: Re: How to determine the number of activity diagra
Post by: qwerty on June 24, 2014, 06:56:50 pm

Quote

PS. You'll probably need to use single quotes in the query from qwerty as well.

Actually no  :D I just copy/pasted that from an EAP query. But maybe for a different RDBMS it would be necessary.

q.

Title: Re: How to determine the number of activity diagra
Post by: Geert Bellekens on June 24, 2014, 08:50:03 pm

Quote

Quote

PS. You'll probably need to use single quotes in the query from qwerty as well.

Actually no  :D I just copy/pasted that from an EAP query. But maybe for a different RDBMS it would be necessary.

q.

Aha, another SQL "Standard" gotcha. :o
If I'm not mistaken single quotes work on both .eap files and DBMS.

Title: Re: How to determine the number of activity diagra
Post by: qwerty on June 24, 2014, 10:31:03 pm

I guess so, but Mickeysoft always likes to implement its own "Standard" :-X

q.