I have a single-select-query input control. The query for this input control accepts parameter:
SELECT id, name FROM tb_products WHERE team_id = $P{TEAM_ID}
Everything is fine when I use this control in report view: $P{TEAM_ID} parameter passed from url to report and input control query as well, filtering products by team.
However, I can't make it work in dashboard. When I setup dashboard parameters mapping, there is no such option to pass dashboard parameters to Filter Group and input control query. So, $P{TEAM_ID} passed successfully to report, but not to input control query. Thus products list appears empty on dashboard's input control.
Please advice, is there a way to filter dashboard input control values by dashboard parameters?
Dashboard cascading input controls
in Products
Posted
I have a single-select-query input control. The query for this input control accepts parameter:
SELECT id, name FROM tb_products WHERE team_id = $P{TEAM_ID}
Everything is fine when I use this control in report view: $P{TEAM_ID} parameter passed from url to report and input control query as well, filtering products by team.
However, I can't make it work in dashboard. When I setup dashboard parameters mapping, there is no such option to pass dashboard parameters to Filter Group and input control query. So, $P{TEAM_ID} passed successfully to report, but not to input control query. Thus products list appears empty on dashboard's input control.
Please advice, is there a way to filter dashboard input control values by dashboard parameters?