Wildcard Search

[Alex Lee Choong Young]

Hi Guys,

I read this help article (http://docs.appery.io/tutorials/build...) on how to build search functionality. I am particularly interested with this section:-
Click Add JS for where parameter and enter the following code:
return '{"Maker":"'+value+'"}';

I just curious if there is a way to implement wildcard search (eg. Where ProductName like '%InputText%')

Thanks in advance !

[Igor]

Hi,

Please try to use $regex operator in your query.

http://docs.appery.io/documentation/b...
http://docs.mongodb.org/manual/refere...
http://docs.appery.io/documentation/r...

[Alex Lee Choong Young]

Thanks Igor! It works like a charm.