Thanks for idea and great article on your blog :-) As I'm using "$X{IN, column_name, listOfValues}", it sems like simbol "%" can't help me. So I set by default $P{listOfValues}=Arrays.asList(new Object[]{"All"}) and use this kind of parameter for sub-query: $P{listOfValues}.contains("All") ? "" : " AND $X{IN, column_name, listOfValues} "