Proper syntax when using a answers to select_multiple question in Inbox query

[NevilleCTT]

I have been trying to get the correct syntax to use the answer to a select multiple question in my inbox query. I am opening the survey that is created from another FS via the inbox for the dwelling survey. 

 So the inbox query works when I say building_type = 1 however this will fail is the answer to building type is 1,2. I have tried using the IN and LIKE operators but these fail.

What can I use? additionally, is there a way to test this inbox query without republishing the survey?

Regards

Neville

[abureaux · Accepted solution]

Have you tried %?

abureaux_0-1723500829068.png

Will find "1" from a list:

abureaux_1-1723500846392.png

More details here.

abureaux_2-1723500856600.png

[NevilleCTT]

it worked, I had the quotes in the wrong place, inside the percentage signs