Messages

1

General Board / Re: Another SQL query..

« on: September 25, 2024, 12:23:49 am »

The elements I would like to find the names for, can be seen in the Properties window.  I need to pull out from CallBehaviorAction  / Bevavior.

2

General Board / Another SQL query..

« on: September 24, 2024, 10:21:11 pm »

Searching through a tree of elements and diagrams, to pull out a list of actions with SQL. Working ok, but I can't figure out how to pull the names of I guess linked activies that are display in a diagram as :Something, rather than a name where in properties in a diagram they have been named.

3

General Board / Acceptance criteria.

« on: March 12, 2024, 08:32:36 pm »

Is there anyway to import acceptance criteria into EA against a lot  of requirements.  Some sort of automated way to process crteria based on a requirement name and add them as a test.

4

General Board / Re: SQL Query - extracting tag iformation and headings.

« on: March 05, 2024, 02:52:04 am »

Putting a COUNT(*) as COUNT from(

<<<The SQL query>>>

) mytable

Did the trick, but probably not the best way.

5

General Board / Re: SQL Query - extracting tag iformation and headings.

« on: February 27, 2024, 10:38:28 pm »

That worked very well.  Do you think there is away to get a count out of the number of rows returned.  That I can set as a variable and atatched to a report or EA template?

6

General Board / Re: SQL Query - extracting tag iformation and headings.

« on: February 15, 2024, 09:45:04 pm »

Thank you I will give that a try.

7

General Board / SQL Query - extracting tag iformation and headings.

« on: February 15, 2024, 09:18:17 pm »

My level of SQL experience is not great (better on the managing database cluster end), but I'm a quick learner and have a lot of experience with pretty much everything else.  Enterprise Architect is new to me, but I'm trying to help some people out with it and improve the information they can pull out of it.  I have an SQL query which does produce some of the results I need, however I wish to also pull out in columns some of the tag information.
What I have so far is this – (which also deals with the fact we have a duplicate model, so I don’t want to pull double the results).
SQL Example –

Select t_object.Name as Name,
          MIN(t_object.Object_ID) as Object_ID,
           t_object.Note as Description,
           t_object.Phase as Phase from t_object
inner join t_objectproperties on t_object.Object_ID = t_objectproperties.Object_ID
where t_object.Object_Type = ‘Requirement’
and t_object.Sterotype = ‘Supporter’
and t_object.Status = ‘Approved’
and t_object.Phase = ‘1’
group by t_object.Name
order by t_object.Name, MIN(t_object.Object_ID)

(With this query I get the columns I need, Name, Object_ID, Description and Phase).  What I would also like is to pull some of the tag information out under heading which is seen below.  But I’m unsure how to do this.  It’s in there somewhere t_objectproperties.Value.

“Tag Names”                             “Values”
Compliance extra detail                              <memo>
Compliance statement                                text
Compliance target                                      Compliant
Design Response                                        text
Hardware Requirements                              No
MVP                                                          No
RMT                                                          No
Specialist Testing                                        No
Verification Method                                     Inspection

Any ideas or suggestions please? Many thanks.