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 Jan 23, 2017 by DanTheMan

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?

Outcomes