Using v2.6 - latest

I have a relation ReportEntry - Disposition (1:n). I want to query for ReportEntryEntities which have n == 0 using adapter.FetchTypedList. Is that possible?

Thanks!

You will have to do something like:

WHERE ID NOT IN (SELECT ReportId FROM Disposition).

And for this you need to use a FieldcompareSetPredicate with the negate parameter set to true.

Like this?

var undisposed = new FieldCompareSetPredicate(ReportEntryFields.ReportEntryId, null, DispositionFields.ReportEntryId, null, SetOperator.In, null) { Negate = true };
filter.PredicateExpression.Add(undisposed);

I have a number of other predicates on ReportEntryFields as well. Is it advantageous to move those into the FieldCompareSetPredicate?

e.g.

filter.PredicateExpression.Add(ReportEntryFields.Deleted == false);

That looks like it should do the trick. I don't think there is any advantage in moving them into the FieldCompareSet predicate unless they need to be there.

Matt

Thanks for your help!