Search use cases with no structured scenarios

[mrblack12]

Hi,

I'm looking for a way to search for use cases for which no structured scenario has been defined yet. Trying to do something with a query that joins the t_object and t_scenarios on object_id's but then I only get the use cases where a structured scenario has been defined, and I'm looking for the ones without.

Any thoughts?

Thanx in advance
Rick

[Geert Bellekens]

use something like

Code: [Select]

select * from t_object uc
where not exists (select sc.ea_guid from t_objectscenarios sc
where sc.Object_ID = uc.object_ID)
Geert

[qwerty]

You probably need to code some sub-select with WHERE (SELECT COUNT(*) FROM t_scenarios WHERE...) = 0
But I'm not a SQL guru like Geert.

q.

P.S. As said xD He was even a bit faster...

[mrblack12]

Geert,

as always your solution works like a charm!

Much obliged....

Rick