AnsweredAssumed Answered

Which operator will return both empty and non-empty fields?

Question asked by ourcalling on Jan 8, 2014
Latest reply on Jan 9, 2014 by ourcalling

I have a script that builds various variable and then applys those to a "Perform Find" query.

The problem I am having is that sometimes the results need to include both empty and non-empty.

 

For examples, I can search for Gender = "Male" or Gender = "Female" or Gender = "*" or Gender = "=".

But how can I search for all records when some have values and others are null (meaning the operator never filled in the gender question).

 

I have the value I want to search in a variable that is passed to the "Perform Find" script command.

This gets really complicated when I want to search by an age range, gender and other various biographical data.

 

 

Thoughts?

Outcomes