Variable in "Query JSON with SQL" does not resolve

App Building
1

I am querying a JSON using "Query JSON with SQL":
select * from {{ getUsers.rawData }} where displayName like "{{txtinp_usersearch.value}}"
txtinp_usersearch.value resolves correctly to "%mike%". However, I get an empty result. If I replace "{{txtinp_usersearch.value}}" by hand with "%mike%" it works fine. What am I missing

2

Hi @JosVanHaag , welcome,

Remove the quotes around {{txtinp_usersearch.value}}, the value already is a string.

1 Like
3

Oh dear, I had a hunch it was going to be slightly embarrassing :slight_smile:
Thanks a lot!

1 Like
4

No worries @JosVanHaag - no need to be embarrassed, thank you for posting here so that others who might run into the same thing can find the solution too :slightly_smiling_face: We all get stuck with things like this from time to time!

Thanks for posting a super quick answer here, @mbruijnpff! :tada: