Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Admin module - search filters when record searching

I was wondering if we could perform the following via the admin module when searching for records ...

1/ Filter on a variable where the variable "is null". If I leave the field blank the filtering does not work as I had hoped.
2/ Filtering on a multiple response question being answered so many times (e.g. where Q1 is answered >1 - similar to the NumChecked function).

Appreciate any comments.
asked Jan 29, 2016 by Paul Moon Platinum (98,670 points)

1 Answer

0 votes
For "null" try this: "".  Just put in two double quotes.  That might work.

Thanks for your feedback we will consider it for future development.
answered Feb 2, 2016 by Justin Luster Silver Sawtooth Software, Inc. (8,300 points)
Thanks Justin.

The "" did not work with = or contains?

The null search appears impossible at this stage.

Any other suggestions? Regards.
Justin, I tried the search where I used = as the operator and then left the last cell blank (the value cell that is). It appears to return records where the variable doesn't have an answer. I can tick that issue off.

If you could also pop the "number of answers" search on to your development log, that would be super. Hopefully it gains some momentum.

Thanks once again for your support. Take care mate.