Is there a way to specify the following query in LLBL?

select * from someTable where ( (someTable.item, someTable.itemdate) not in (select otherTable.item, otherTable.itemdate from otherTable ) )

LLBL 3.1, Self-Servicing, ODP.Net DQE

Thanks for any assistance.

I didn't know you can do that. This is not supported, you should use EXISTS instead: pass null to the field paramter and specify a filter:

bucket.PredicateExpression.Add(new FieldCompareSetPredicate(
    null, null, OtherFields.Item, null,
    SetOperator.In, (SomeFields.Item == OtherFields.Item & SomeFields.ItemDate == OtherFields.ItemDate)));

which will generate:

WHERE EXISTS
  (SELECT OtherTable.Item
    WHERE SomeTable.Item = OtherTable.Item AND SomeTable.ItemDate = OtherTable.ItemDate)

It's an oracle specific feature, if I recall correctly. Not supported directly.