We have an input parameter which is multi select query.
This is a cascading input control and its value is dependent on 2 other input controls which is defined in the reoprt.
Below is the query :-
SELECT DISTINCT
CF_COMPONENT AS NAME,YEAR_NAME,CF_APP_OWNER_USER_UID FROM CF_DWH_CI_INV_TOS_DTD_ACTUALS
WHERE CF_APP_OWNER_USER_UID=$P{APPOWNER} AND YEAR_NAME=$P{Component_Year}
ORDER BY CF_COMPONENT
The input control works perfectly while running as a report. But when draging the report to a dashboard It is not working.
If I remove one AND condition from the Input control query It will work in dashboard also.
like :-
SELECT DISTINCT
CF_COMPONENT AS NAME,YEAR_NAME,CF_APP_OWNER_USER_UID FROM CF_DWH_CI_INV_TOS_DTD_ACTUALS
WHERE CF_APP_OWNER_USER_UID=$P{APPOWNER}
ORDER BY CF_COMPONENT
Note :- This was working fine in jasperserver version 6.2. We faced this issue after upgrading Jasper Server from verion 6.2 to verion 6.4.2_5.4.2
Please shed some light.
