Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. 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" } ] } };