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

    Entity Query Restrictions problem

    terryb

      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})