Hi Stephen,
It seems to me like the filter is incorrect. Our accepted filters are explain in our
WSAPI Page . See in the Introduction section, I'm also including a screenshot:
Essentially the format is:
((((((a) OR (b)) and (c)) and (d)) and (e)) and (f))
So for your case it should be:
((((((Application = "A") OR (Application = "B")) AND (Workflow != "")) AND (Workflow != "X")) AND (Workflow != "Y")) AND (Workflow != "Z"))I hope this helps. Let us know.
Thanks,
Sagi
Original Message:
Sent: 04-02-2020 04:51 PM
From: Stephen Grasso
Subject: Excel Add-In Query Filter Error
I've been successfully using the Excel add-in (V 2.4.4) for quite some time. However, I recently needed a larger set of filter criteria. This resulted in the following error message. "Could not parse: Error parsing expression -- expected ")" but saw "AND" instead."
Here's a simplified version of the filter:
(((Application = "A") OR (Application = "B")) AND (Workflow != "") AND (Workflow != "X") AND (Workflow != "Y") AND (Workflow != "Z"))
As a test I used the same filter as a query in a Custom List and it worked without error.
Any help would be appreciated!
------------------------------
Agile Coach
Boston, MA
------------------------------