Have an idea?

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

Admin Module Filter Search for null

I was wondering if the search facility within the admin module has the power to display surveys where a variable's value is null?

I have a select question (with possible codes 1-11) and was having trouble getting it to display the correct number of records.

I can check in the Advanced menu option but was hoping the search menu option could assist.

Any help is much appreciated.
asked Jan 15, 2015 by Paul Moon Platinum (67,375 points)

1 Answer

0 votes
I don't think we have a specific option for null, but I think if you build a search like variable = and then leave the last cell blank, it should return records where the variable doesn't have an answer (seemed to work in the quick test I just ran).
answered Jan 20, 2015 by Brian McEwan Gold Sawtooth Software, Inc. (38,865 points)
Thanks Brian. Ill give that a try later today. Appreciate your advice.