Community Tip - Did you know you can set a signature that will be added to all your posts? Set it here! 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" } ] } };