Forum | Appery.io

Hi there, I followed tutorial and it showed me how to search in 1 column. But how can I use the where for multiple columns?

See in my img i link on textbox already to the where and i whant to link the second textbox also to the where.

The code in the where is the following="return '{"provinsie":"'+value+'"}';"

Hello Johnny,

This should help https://devcenter.appery.io/documenta...

Thank you, dumb question do i then connect all the fields to the "where" and do that js script?

I get the Query working when i have fix values for example:
return '{"$and": [{"provinsie": "Gauteng"},{"taal": "Afrikaans"}]}';

But when i try this with this mapping:
return '{"$and": [{"provinsie": "'+value+'"},{"taal": "'+value+'"}]}';

It not working, see image

Hello Johnny,

This doesn't work because of you didn't add mapping arrow to "where" parameter and use "value" variable inside of it. Please add this arrow.

Dude i tried it, see above code not image but the code.I tried mapping both to where and use value. The image part is what i tried.

What for other fields (taal, provinsie)? Please remove them. (http://prntscr.com/7h9dph)
If you need use these both parameters, please use JS:

return '{"$and": [{"provinsie": Apperyio("txt_provinsie").text()},{"taal": Apperyio("txt_afr").text()}]}';