Filter for "difficulty" in a requirement?

[Roland Ziegler]

Hi there,

I'm trying to search a model (Model Search) for "Requirement" elements where the "Difficulty" element field is set to "High" (or any other value) - without success.

Searching for "Priority" set to "High" does work.

Any specific tricks here which I missed?

EA 8.0 build 861


Thank you

[Geert Bellekens]

I'm guessing you are trying this using the search builder?
I always use the SQL search type.
The Difficulty is stored in pdata3
You can use something like this:

Code: [Select]

select o.ea_guid as CLASSGUID,o.object_type as CLASSTYPE,o.name as Name
from t_object o
where  o.Object_Type = 'Requirement'
and o.pdata3 like 'High'
and o.name like '<Search Term>'
Geert

[sargasso]

(( All "difficult" requirements are intentionally hidden. ))
b

[Roland Ziegler]

(( All "difficult" requirements are intentionally hidden. ))

That seems to be the case.  

I'm guessing you are trying this using the search builder?
I always use the SQL search type.
The Difficulty is stored in pdata3

Actually I was hoping for a solution with the standard "Search Builder". However, the SQL query provided does the trick. Problem solved, technically speaking. Thanks a lot.
 
But how would you know that pdata3 stands for "Difficulty" (context dependent I guess)?

[Geert Bellekens]

But how would you know that pdata3 stands for "Difficulty" (context dependent I guess)?

Trial and error

Geert