Multi-Value values in column, parameter needed and need a wildcard

[QueenArtemis]

Okay, so here it goes. Using Jaspersoft Sudio Pro 6.2.1. Oracle DB. I need some help on how to use a parameter that contains wildcard.

In my query, i have values in a column that could contain multiple values. 

1 single row containing multi values in the columns.

 

i need to create a parameter (multi select) to get these values. 

if i use:

AND portfolio.code LIKE '%pro_other%' within the query, this works perfectly. it will return the correct results with pro_other and then those rows that contain %pro_other%.

Now, I tried to make the parameter within the jrxml: AND $X{IN, portfolio.code, portfolioKey_1} 

This works, however, it will only give me the specific values that ONLY have "pro_other" in the values. 

I have tried this: AND portfolio.code IS NULL OR portfolio.code LIKE '%' || '$P!{portfolioKey_1}' || '%' and this gives me the error: 

java.sql.SQLException: Execute Query fail.Execute Query fail.Invalid column index

My parameter is java.util.Collection

Anyone have any ideas,  i would be so very grateful.

Sincerely,

Keri

[QueenArtemis]

figured it out...