Is there something like `SQL WHERE ID IN (id1, id2, …, idn)`


#1

Looking for a list of BillingAccounts by there IDs, I am seeking something equivalent to this SQL statement in C3 expression capabilities.

SQL WHERE ID IN (id1, id2, …, idn)

Something like:

BillingAccount.fetch({filter:'id IN ["512711976", "511922882"]'})

But there is no IN :tired_face:


#2

You can use intersects:

BillingAccount.fetch({filter: ‘intersects(id, [“512711976”, “511922882”])’})


#3

Like a charm, thank you!