FInd all elements of type Issue

[GrahamL]

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

Thanks

[qwerty]

SELECT * FROM t_object WHERE object_type = "Issue"

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

[GrahamL]

Thanks but I get 'Invalid column name 'issue'

[qwerty]

Means you have not entered the query correctly as above.

q.

[GrahamL]

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

[qwerty]

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.

[KP]

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

Code: [Select]

SELECT * FROM t_object WHERE Object_Type = 'Issue'

[qwerty]

Ah, the quotes for SQL Server....

q.