Dashboard cascading input controls


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?

azemliankin's picture
Joined: Dec 20 2016 - 12:29am
Last seen: 2 years 11 months ago

0 Answers:

No answers yet