Discussions
Nested filters in Workorder Query API
2 months ago by Vaishali
The below is my request body but the second/child condition "PickUp" does not execute, its as if it does not exist in code, can anyone tell me if i am using the right syntax for nested conditions ? ( (filter 1 or filter 2) AND (filter 3))
{
"QueryExpression": {
"Criteria": {
"Conditions": [
{
"PropertyName": "Filter1",
"Operator": "Equal",
"Values": ["a"]
},
{
"PropertyName": "Filter2",
"Operator": "Equal",
"Values": ["a"]
}
],
"FilterOperator": "or",
"Criteria": [
{
"Conditions": [
{
"PropertyName": "Filter3",
"Operator": "NotIn",
"Values": ["a", "b"]
}
]
}
]
},
"Distinct": true,
"PropertySet": { "Properties": ["*"] },
"Count": 100,
"FirstResultIndex": 0
}
}