mismatched input '$P!{__#param1}' expecting ')'

[cek.i06go]

select count(distinct case when (o.id is not null $P!{__#param1}  $P!{__#param2} ) then o.id end) as Number, o.typefrom OST owhere o.type is not nullgroup by o.typeorder by o.type[/code]

when i write this query in my data set, JasperStudio indicate me this error:

mismatched input '$P!{__#param1}' expecting ')'

and i can't execute the report.

I'm sure that the content of param1 and 2 it's ok (and if i remove one of them, the query work).

How i can resolve this?

[hozawa]

You haven't told us which database you're using.

try inserting AND

[cek.i06go]

I using DB Oracle 10g.

 

[cek.i06go]

translated, the select query is this:

SELECT count(DISTINCT CASE WHEN ((o.id IS NOT NULL)  AND (o.activate BETWEEN (TO_DATE('01/01/2014', 'dd/mm/yyyy')) AND (TO_DATE('26/02/2014', 'dd/mm/yyyy')))  AND ((o.validate BETWEEN (TO_DATE('23/01/2014', 'dd/mm/yyyy')) AND (TO_DATE('20/02/2014', 'dd/mm/yyyy'))) AND o.play LIKE 'Close')) THEN o.id END) AS number, o.type[/code]

and i have always the same error... why??