svySearch for searching for empty or null values

Hi

How could we search for an empty or null value with “svySearch”. For example: Our customer want to search for all addresses that don’t have any value in field “phone_nr_home”.

When we use “find” and “search” on a foundset, we could enter “^=” in this field. But how to achieve this with svySearch?

Best
Roland

Hi Roland,

My humble opinion is that it sounds like you are looking for a filter than a search.

SvySearch does support some operators and other tricks, but it is intended to a be a free-form text search (like google for your DB).

Please check out the Filter section of the Working With Data guide to filter programmatically.

If you are looking for GUI implementations of filtering and SvySearch together, then check out the SvyPopupFilter module. It’s great!

Best,
Sean