It's all about the answers!

Ask a question

How do I use Advanced Search in Web Client for assets that have NULL or missing value for a particular attribute?


Pankaj Sharma (123) | asked Feb 22 '13, 11:18 a.m.
edited Feb 22 '13, 1:38 p.m.
The attribute name is Shared Scope and I have tried:
attribute:('Shared Scope'='*') 
attribute:('Shared Scope'='') 
attribute:('Shared Scope'=NULL) 
attribute:('Shared Scope' is NULL) 

None of these work

One answer



permanent link
Rich Kulp (3.6k38) | answered Feb 22 '13, 6:51 p.m.
FORUM MODERATOR / JAZZ DEVELOPER
edited Feb 22 '13, 6:53 p.m.
You can only search for attributes that are set or not set. NULL is not a valid attribute setting so there is no way to search for it.

To do a negative search (i.e. all that do not have attribute set for them) use:

!attribute:('test'='*') *


Note the ! on the beginning and the space * on the end. Those are important. Without them the invert search doesn't work and you will get nothing back. Just replace test with the name of the attribute of interest.

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.