Greetings,

I am new to trying more advanced filtering with the predicate logic. Can anyone help me translate this query into predicate logic:

select * from a where not exists (select 1 from b where b.key=a.key)

(or achieve the same goal which is selecting all rows from an entity that are not related to by another entity).

Thanks!

Hi scotru,

In this case you should go on "FieldCompareSetPredicate". There are a bunch of information at forums. Also review the LLBLGenPro Help.

Are you using SelfServicing or Adapter?

Thanks--I'll take a look at that. Self-Servicing.

Was able to accomplish what I wanted with:

            IPredicateExpression selectFilter = new PredicateExpression();
            selectFilter.Add(new FieldCompareSetPredicate(MailboxesFields.MailboxId, RoomsFields.MailboxId, SetOperator.NotEqualAny,(RoomsFields.MailboxId != DBNull.Value),false));
            selectFilter.AddWithAnd(MailboxesFields.BuildingId == building.BuildingId);
                mailboxes.GetMulti(selectFilter);

with reference to this thread:

http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=6202

Thanks for your help!