expression IN (value1, value2, .... value_n);

Posts   
 
    
Anthony
User
Posts: 155
Joined: 04-Oct-2006
# Posted on: 20-Sep-2017 16:00:20   

llglgen 3,c#, adpater mode

I want to be able to create an equivalent of

invoiceno IN (value1, value2, .... value_n);

i have this at the momnent

invoiceFilter.PredicateExpression.Add(InvNumFields.InvNumber = InvoiceNo)

but need something like

invoiceFilter.PredicateExpression.Add(InvNumFields.InvNumber in ["7767676","976767"])

Walaa avatar
Walaa
Support Team
Posts: 14950
Joined: 21-Aug-2005
# Posted on: 20-Sep-2017 21:21:26   

e.g.

int[] values = new int[3] {1, 2, 5};
bucket.PredicateExpression.Add(new FieldCompareRangePredicate(
    OrderFields.EmployeeId, null, values));

ref: FieldCompareRangePredicate