Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X
I would like to run a two part query that as a type of "And" and "Or". Something like this:
var query2 = { "filters": { "type": "Or", "filters": [ { "type": "Matches", "fieldName": "Name", "expression": "Asset_1" }, { "type": "Matches", "fieldName": "Name", "expression": "Asset_2" } ], "type": "AND", "filters":[ { "fieldName":"modelNumber", "value":"theModelNumber", "type":"EQ" } ] } };
Although this seems like it should match, it does not return anything. I can not find an example of this kind of query, I'm guessing my syntax is wrong somehow. Has anyone every done this before?
It should look like this for anyone who may have the same question.
var query2 = { "filters": { "type": "AND", "filters": [ { "type": "OR", "filters": [{"type": "Matches","fieldName": "Name","expression": "Asset_1"}, {"type": "Matches","fieldName": "Name","expression": "Asset_2"}] }, { "fieldName":"modelNumber","isCaseSensitive":true,"value":"theModelNumber","type":"EQ" } ] } };