Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Using an IN statement

My customer wants to search based on a list of items. If it were SQL it would look something like this...

Select * from table A where idnumber IN (1,2,90,1000,11)

The field to be search is an integer and is the primary key. The number of items in the IN clause could be up to 100.

I tried setting a Search Option to $in but that does not seem to work on this field.

How would I go about setting up a search dialog that would allow for the items to be entered.

1 person has
this question