Discussions
Contains in a query
10 months ago by James Roggeman
HI I'm trying to do a query with a Contains operator and I keep getting an error '"ErrorMessage": "This condition requires 2 values while only 1 values were supplied.\r\nParameter name: values". I have tried Contains and Contain with the same result. See my code below. I'm searching for Procedure steps that contain the word Lighting.
{
"QueryExpression":
{
"Criteria": {
"Conditions": [
{
"PropertyName": "WorkOrderId",
"Operator": "Equal",
"Values": ["1181159"]
},
{
"PropertyName": "ProcedureTemplateStep.Description",
"Operator": "Contains",
"Values": ["Lighting"]
}
]
}
}
}