Issue with input parameter in dashboard - JasperServer 6.4.2_5.4.2

0

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.

harun.prasu's picture
Joined: Oct 16 2015 - 2:39am
Last seen: 1 year 1 month ago

0 Answers:

No answers yet
Feedback