0 Replies Latest reply on Nov 3, 2008 4:39 PM by Terry

    Entity Query Restrictions problem

    Terry Apprentice

      How can one create restrictions for following since it won't allow more than one value binding?


      SELECT ...
      FROM table1 t1
      WHERE t1.column1 like #{e1} AND 
            ...
            t1.column6 like #{e6} AND 
            (t1.column7 like {e7} OR t1.column8 like #{e8} OR t1.column9 like #{e9})