Querying COQL Multi-Select field

Querying COQL Multi-Select field

Hello,

I added to the Price_Books module 2 simple multi-select fields: Countries and Devices,
and a few other fields.

I tried the following COQL queries:

  1. select id,Price_Book_Name,Active,Countries,Devices,Link,Created_Time from Price_Books where Countries like '%United States%' and Devices like '%ios%' and Type = 'External' limit 200 offset 400
  2. select id,Price_Book_Name,Active,Countries,Devices,Link,Created_Time from Price_Books where Countries = 'United States' and Devices = 'ios' and Type = 'External' limit 200 offset 400
  3. select id,Price_Book_Name,Active,Countries,Devices,Link,Created_Time from Price_Books where contains(Countries, 'United States') and contains(Devices, 'ios') and Type = 'External' limit 200 offset 400
  4. select id,Price_Book_Name,Active,Countries,Devices,Link,Created_Time from Price_Books where 'United States' in Countries and 'ios' in Devices and Type = 'External' limit 200 offset 400
But Nothing seems to work.

How should I write the query correctly so that I'll be able to query all Price_Books that have 'United States' selected in the multi-select Countries, 'ios' selected in Devices and Type equals to 'External' ?

Please assist 🙏


      • Sticky Posts

      • Kaizen #217 - Actions APIs : Tasks

        Welcome to another week of Kaizen! In last week's post we discussed Email Notifications APIs which act as the link between your Workflow automations and you. We have discussed how Zylker Cloud Services uses Email Notifications API in their custom dashboard.

      • Kaizen #216 - Actions APIs : Email Notifications

        Welcome to another week of Kaizen! For the last three weeks, we have been discussing Zylker's workflows. We successfully updated a dormant workflow, built a new one from the ground up and more. But our work is not finished—these automated processes are

      • Kaizen #152 - Client Script Support for the new Canvas Record Forms

        Hello everyone! Have you ever wanted to trigger actions on click of a canvas button, icon, or text mandatory forms in Create/Edit and Clone Pages? Have you ever wanted to control how elements behave on the new Canvas Record Forms? This can be achieved

      • Kaizen #142: How to Navigate to Another Page in Zoho CRM using Client Script

        Hello everyone! Welcome back to another exciting Kaizen post. In this post, let us see how you can you navigate to different Pages using Client Script. In this Kaizen post, Need to Navigate to different Pages Client Script ZDKs related to navigation A.

      • Kaizen #210 - Answering your Questions | Event Management System using ZDK CLI

        Hello Everyone, Welcome back to yet another post in the Kaizen Series! As you already may know, for the Kaizen #200 milestone, we asked for your feedback and many of you suggested topics for us to discuss. We have been writing on these topics over the