cancel

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

SOLVED
Go to solution
Highlighted
Luke1
Trusted Contributor.

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
David Churchland
Acclaimed Contributor.
Solution

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 MicroFocus**
Rich_Kid
Outstanding 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.