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 #198: Using Client Script for Custom Validation in Blueprint

      Nearing 200th Kaizen Post – 1 More to the Big Two-Oh-Oh! Do you have any questions, suggestions, or topics you would like us to cover in future posts? Your insights and suggestions help us shape future content and make this series better for everyone.
    • Kaizen #226: Using ZRC in Client Script

      Hello everyone! Welcome to another week of Kaizen. In today's post, lets see what is ZRC (Zoho Request Client) and how we can use ZRC methods in Client Script to get inputs from a Salesperson and update the Lead status with a single button click. In this
    • Kaizen #222 - Client Script Support for Notes Related List

      Hello everyone! Welcome to another week of Kaizen. The final Kaizen post of the year 2025 is here! With the new Client Script support for the Notes Related List, you can validate, enrich, and manage notes across modules. In this post, we’ll explore how
    • 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