How do I use Advanced Search in Web Client for assets that have NULL or missing value for a particular attribute?
One answer
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.
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.