AnsweredAssumed Answered

Is it possible to use a LIKE statement (or equivalent) in a choice_filter?

Question asked by DanTheMan on Jan 22, 2017
Latest reply on Jul 11, 2019 by dougbrowning

I want the end-users to select a single Spot Check Code (A, B, C or D).


I then want to use that value in something similar to a LIKE statement to extract matching records from the external_choices tab.  There are different combinations of A, B, C & D depending on inspection frequency for each feature, so an exact match does not work.


XLSForm currently looks like this:


In testing, I also noticed that using an OR operator returned no records...I expected that all records with a matching CP_System would have been returned.


Has anyone done something similar?