Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: GrahamL on November 11, 2021, 10:51:30 pm

Title: FInd all elements of type Issue
Post by: GrahamL on November 11, 2021, 10:51:30 pm

Hi
Been away from EA for a while
How do I use model search to find all elements that are of type Issue

Thanks

Title: Re: FInd all elements of type Issue
Post by: qwerty on November 12, 2021, 12:14:03 am

SELECT * FROM t_object WHERE object_type = "Issue"

You might add those CLASSTYPE stuff but that one works as well.
q.

Title: Re: FInd all elements of type Issue
Post by: GrahamL on November 12, 2021, 12:57:03 am

Thanks but I get 'Invalid column name 'issue'

Title: Re: FInd all elements of type Issue
Post by: qwerty on November 12, 2021, 02:05:37 am

Means you have not entered the query correctly as above.

q.

Title: Re: FInd all elements of type Issue
Post by: GrahamL on November 12, 2021, 02:18:22 am

Copied and pasted into new model search's SQL editor - still get the same

Title: Re: FInd all elements of type Issue
Post by: qwerty on November 12, 2021, 06:22:28 am

Can't be (or so). The message says that you try a SELECT ... FROM Issue which would obviously be wrong. Which EA version is yours?

q.

Title: Re: FInd all elements of type Issue
Post by: KP on November 12, 2021, 07:39:30 am

What's your DB type? It might not like double quotes. Try

Code: [Select]

SELECT * FROM t_object WHERE Object_Type = 'Issue'

Title: Re: FInd all elements of type Issue
Post by: qwerty on November 12, 2021, 09:59:27 pm

Ah, the quotes for SQL Server....

q.