[Ireport parameter]

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?

[How to display an image from PostgresSQL with iReport 5.5.0]

I'm using iReport 5.5.0. I would like to display images store as byte array in Postgres on my report. How can i do that?