Showing results for 
Search instead for 
Do you mean 

HPRM 8.01 - How do i search for a null value?

SOLVED
Go to Solution
Occasional Advisor

HPRM 8.01 - How do i search for a null value?

Hi,

How would I search for all records that have a null value in any given field? ie show me all records where abc field is null / empty / has no data in it?

Much thanks

 

2 REPLIES
Honored Contributor

Re: HPRM 8.01 - How do i search for a null value?

I have only tested in 8.3 but I imagine 8.01 would be similar.

 

I assumed that when you said 'field' you meant 'Additional Field'.  If so the answer depends on the field type.  For a numeric you would do > 0, e.g. AlchololLevel > 0

 

For a string field use an empty string. e.g. MyField:""


Blog | Samples | HPE CM 9.1 SDK Docs
**Any opinions expressed in this forum are my own personal opinion and should not be interpreted as an official statement on behalf of Hewlett Packard Enterprise**
Honored Contributor

Re: HPRM 8.01 - How do i search for a null value?

Additional fields can also be locations so to find null values I use

not MyLocation:*

i find this works well for trim property searches as well.

//Add this to "OnDomLoad" event