Hello

I have the folowing code:

OrderCollection result = new OrderCollection();
            IPredicateExpression filter = new PredicateExpression();
            filter.Add(OrderFields.CustomerID == customerID);
            filter.Add(new FieldCompareSetPredicate(OrderFields.OrderID, OrderInvoiceFields.NewInvoiceOrderID, SetOperator.In, null));
            result.GetMulti(filter);

which generates something like this:

select * from order where order.OrderID IN (select NewInvoiceOrderID from ......)

Instead of where order.OrderID IN I want it to be where order.OrderID NOT IN. How do I do that?

Use the extra paramtere overload of the function:

public FieldCompareSetPredicate( 
   IEntityField field,
   IEntityField setField,
   SetOperator operatorToUse,
   IPredicate filter,
   bool negate
)

The last parameter is bool negate.

I also guess you can try this code out:

filter.Add( ! new FieldCompareSetPredicate(OrderFields.OrderID, OrderInvoiceFields.NewInvoiceOrderID, SetOperator.In, null));

Note the '!'.

Thanks

They both works