Hi
I have a query service. Return values from the db that contain an exact match works fine. However how do I use the Contains argument to retrieve any data that contains any part of the searched for data?
return('contains({"Client": "' + (value) + '"})');
Does not work. Not sure if is a syntax issue or if this method cannot be used.
Thank you.
Hello Deon,
You can use
pre$regex/pre
This links should help:
http://docs.appery.io/documentation/b...
http://docs.appery.io/documentation/r...
http://docs.mongodb.org/manual/refere...
Thanks, but I am battling with the syntax.....
I want the same result as this
return('{"Client": "' + value + '"}');
but return any part and any case
I have tried various things ie.
return('{"Client":{"$regex": "' + value + '", "$option": "i"}}');
but cant get it to work
Try this variant:
return('{"Client":{$regex: "' + value + '"}}');
Does work but is case sensitive.
Please take a look at screenshot,
code from where clause:
pre{'Name':{$regex:"test"}}/pre
return('{"Client":{$regex: "value"}}'); does not work at all
value = variable that could be anything
This works
return('{"Client":{$regex: "'+ value +'"}}');
but but you have to type the exact case
For cas insensitive I tried this but it does not work
return('{"Client":{$regex: "'+ value +'", "$option": "i"}}');
This works.....
return('{"Client":{$regex: "'+ value +'"}}'); but is is case dependent.
now to remove case sensitivity I do this as suggested in other posts
return('{"Client":{$regex: "'+ value +'", "$option": "i"}}');
It does not work. It is still case dependent.
With reference to your post...
http://docs.mongodb.org/manual/refere...
syntax for $option is $options???? Which is the correct syntax
This is very confusing, there is no consistency in syntax. I never know when to use " or '. It seems there are many variations of the same thing and it is a hit and miss.
Hi Deon,
Please try this:
pre
{"Client":{$regex: "'+ value +'", $options: 'i'}
/pre