You’re offline. This is a read only version of the page.
Announcements
2
We are using AND & OR operator in filter query on Getitem (sharepoint) card but getting below error
Filter query syntax : (Status eq 'A' AND (DateOfJoin eq '2020-06-19' OR substringof('07-20',DateOfBirth))
Error: The expression "(Status eq 'A' AND (DateOfJoin eq '2020-06-19' OR substringof('07-20',DateOfBirth))" is not valid. Creating query failed. clientRequestId: dd21470d-849f-4954-92cf-8501cac0c273 serviceRequestId: dd21470d-849f-4954-92cf-8501cac0c27
How we can achieve using AND & OR operator in single query
Hi @harshadb ,
First, make sure that each individual filter is valid. You could configure these filters separately in Filter Query and test them separately.
It should be noted that the calculated column and Choice filed cannot be configured in Filter Query.
Best Regards,
Share
Report
All responses (
Answers (
