2 Replies Latest reply on Sep 7, 2011 6:46 PM by nathan dennis

    how to use Logical operators in EJBQL

    Saravanan Vijaya Manoharan Newbie
      HI,

      Could any one help me creating a EJBQL and Restriction for the SQL statment as below
      (because i am very new to SEAM)

      STATEMENT 1
      ------------------------------------------------------------------------------------------------------
      SELECT * FROM roe.project WHERE (process_owner LIKE '%a%' OR project_name LIKE '%s%') AND userid='admin';
      ------------------------------------------------------------------------------------------------------

      The problem here is when i use the Restriction logical operators 'OR' and 'ANY' i found that the rendered query was

      STATEMENT 2
      ------------------------------------------------------------------------------------------------------
      SELECT * FROM roe.project WHERE userid='admin' OR process_owner LIKE '%a%' OR project_name LIKE '%s%';
      ------------------------------------------------------------------------------------------------------

      is there any ways to create a EJBQL that looks like STATEMENT 1