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 🙏