I'm using iReport 5.5.0 to create a report. I'm using a parameter with parameter class set to 'java.lang.String' with a default value expression. I would like to integrate it to my SQL query.
Bellow my query:
SELECT * FROM table WHERE product."code" ILIKE '$P!{parameter}'
Preview does not work and i get a error.
Also I tried to use the parameter wihtout the exclamation sign (!) and without quote ' but it still doesn't work at all
Can you help me?
0 Answers:
No answers yet