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