Highlighted
Outstanding Contributor.
Outstanding Contributor.
171 views

Searching for NULL values in binary fields.

Jump to solution

I have a binary field that I am searching against on the device format: advFind.search.ci
I can typically search for true or false values using Checkboxes, display lists in Combo Boxes or Radio buttons.
But I also need to search for NULL values and my 3 listed widgets do not allow for "NULL" searches on binary fields.
Would anyone have any suggestions.

I seem to remember that older SC/SM versions had checkboxes with a characteristic of clicking on it twice and it turned into a null search, but alas no more...

 

0 Likes
1 Solution

Accepted Solutions
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Try going to the Object record and into the Search Configuration tab, then add a Defined query of <field>=NULL

View solution in original post

2 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

Try going to the Object record and into the Search Configuration tab, then add a Defined query of <field>=NULL

View solution in original post

Highlighted
Outstanding Contributor.
Outstanding Contributor.

Thanks Tom.

It's not as clean as I would of liked, but it will do assuming the user accepts it. We've never really used the Object search xml based configurations because I never really understood how it worked internally, but I guess there comes a time for most anything.

Would there be a cleaner method using FD widgets?  I'll wait a couple of days and if no replies, I'll accept this as a solution.

Thanks!

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.