Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. 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" } ] } };