I am trying to place a "
contains query" in my data services query. When debugging I see that the correct value is being passed or captured, but I am not constructing the query correctly.
When I click the "add JS" button for the "where" clause, I add the following: return '{"color_number": "'+value+'"}'; I have tried various on this including return '{"color_number": {"$in":["'+value+'"]}}';but can't seem to get it to working. Any assistance would be appreciated.
Am I going about this the correct way?. As the questions before and after mine have been I addressed - I wanted to see if I am missing/overlooking something.
Hi Daniel,
Please clarify as it's not clear what you are trying to do, you saying that you see that the correct value is being passed - where do you see this?
Also please show the structure of your mapping as its not clear how you are adding "add JS" to the "where" clause.
Hi Illya Sorry. I was not sure how much detail to provide. Let me pull a few images together.
I have created a page with the images showing what I have done lfwebz.biz/apq/mood.html
Hi Daniel,
Could you please clarify whether color_number is an array of numbers or strings? If numbers, try the following:pre return '{"color_number": {"$in":['+value+']}}';/pre
Goodness, thanks so much - that got it working.