Author Topic: How to determine the number of activity diagrams  (Read 4084 times)

aguevara

  • EA User
  • **
  • Posts: 27
  • Karma: +0/-0
    • View Profile
How to determine the number of activity diagrams
« 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]

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: How to determine the number of activity diagra
« Reply #1 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.

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: How to determine the number of activity diagra
« Reply #2 on: June 24, 2014, 09:42:31 am »
Also look at the Project Statistics page from Project | Project Status.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to determine the number of activity diagra
« Reply #3 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.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: How to determine the number of activity diagra
« Reply #4 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.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13404
  • Karma: +567/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to determine the number of activity diagra
« Reply #5 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.

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +396/-301
  • I'm no guru at all
    • View Profile
Re: How to determine the number of activity diagra
« Reply #6 on: June 24, 2014, 10:31:03 pm »
I guess so, but Mickeysoft always likes to implement its own "Standard" :-X

q.