Post
FollowCZQL query WHERE operator for multipick list eg. "contains"
Background:
I'm using the api to pull info from Clarizen and then populate an external dashboard.
Problem:
In the query I only want to pull the info from milestones that contain the value "Cheese" in the C_Dashboard field (a multi-pick picklist). This works as long as it is the only item selected in that field but ceases to work as soon as another value is selected (eg. "Cheese" and "Wine")
SELECT Name, Duedate
FROM Milestone WHERE (State IN ("active") AND C_Dashboard LIKE "Cheese")
Request:
Currently neither LIKE or "=" operator work for this so an addition of a contains operator would be great.
There is a current workaround for this in the following community post:
Please sign in to leave a comment.