1 Reply Latest reply on Dec 23, 2009 12:56 PM by blabno

    Entity query restrictions for with and is null

    Roger Mori Newbie

      How should the EntityQuery restrictions should be set for the following named query.

      @NamedQuery (
         name  = "abc",
         query =  " select p from GeneralType p 
                    left outer join p.preferences q with q.party.id = :pid "
                    where preference.id is null " 

      Any help is appreciated.

      Thank you.