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

    Entity query restrictions for with and is null

    rogermorituesta.rogermori.yahoo.com

      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.


      Roger.