User parameters in Query-based Input Controls don't work

[jacobs_1]

when I run a report using this Query-based Input Controls

select distinct COLUMN from TABLE where COLUMN is not NULL and $P{LoggedInUser}='Administrator'

I get

net.sf.jasperreports.engine.JRRuntimeException: Parameter "LoggedInUser" does not exist.

[jacobs_1]

You have to define an input control that take no information.

Incase of user roles you have to define an input control multi select from list with the name and Id LoggedInUserRoles and an empty list.

edit: it is better create the input control as multi select (select * from jirole) and add the property select_all:true to the parameter in ireport.