Post

1 follower Follow
1
Avatar

CZQL 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:

Robin Head Not planned

Please sign in to leave a comment.