When making ORDA queries, it's common to simply create a query string which compares one value is equal to another value. Let's say we want to query all clients that are residing in the west coast.

C_OBJECT($es) $es:=ds.Client.query("state = AL | state = AZ | state = CA | state = CO | state = MT | state = WA")

However, this type of query can become very long. Another way to query is to compare whether one value is included in a set a values or a collection using the IN operator which can shorten the query string and makes it much easier to read.

C_OBJECT($es) C_COLLECTION($states) $states:=New collection("AL";"AZ";"CA";"CO";"MT";"WA") $es:=ds.Client.query("state IN :1";$states)