Pre-select all options for 'multi-select query'?

[manakhimova]

Does anybody know, how to pre-select all options for 'multi-select query' input control?

[gabrielinux]

I'm not sure how you can do that, but there is a work around. You can always append a value called "All" whose value is a "%" sign.

See this example: http://jasperforge.org/plugins/espforum/view.php?group_id=112&forumid=102&topicid=45590

 

[manakhimova]

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} "

[gabrielinux]

Oh now I see what you are doing. The example above is for the SQL query itself, not for parameters, so you are correct -- it won't work in this case.

 

But I think the parameter above should work. It makes sense to append " AND $X{IN, column_name, listOfValues}" only when the listOfValues does not contain All.

[jasperjones999]

 

gabrielinux

do not post a link to a 1000 pages of help or comments, a link to Google would have been more useful, your link was not.

moderators remove 

gabrielinux link..... just wastes time