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 %?

Will find "1" from a list:

More details here.

[NevilleCTT]

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