Discussions

Ask a Question
Back to All

Equals condition value order matters?

I am sending a query to the model endpoint. If I send the "Values" in numerical order then I get a result back, but if they are out of order it does not return any matches. Is this the correct behavior? I assumed that the "Equals" condition was matching any value in the array but is that not the case?

This returns data:
{
"QueryExpression": {
"Criteria": {
"Conditions": [
{
"PropertyName": "Description",
"Operator": "Equal",
"Values": [
"Air Conditioning and Heating (Int)"
]
},
{
"PropertyName": "Id",
"Operator": "Equals",
"Values": [
3143,
3144
]
}
],
"FilterOperator": "And"
},
"Distinct": true,
"PropertySet": {
"Properties": [
"Id",
"DisplayAs",
"Description"
]
},
"Count": 0,
"FirstResultIndex": 0
}
}

If I send in the Id Equals condition like this it returns no data:

                           {
				"PropertyName": "Id",
				"Operator": "Equals",
				"Values": [  
					3144,  
					3143  
				]
			}