Problem With Cascadin Parameter also using usernam

[ramandeep1980]

 

Hi,

We are facing a major trouble in regard to refreshing of cascaded or dependent parameter.

That also using the username as one of the parameters.

 

We have got 2 parameter of Single Select(X) and Multi-select(Y) type respectively.

Till the time we do not change/Update the values existing for Y in the back end everything goes fine. But the moment we change the existing value of Y showing for particular value of X and LoggedInUserName (LoggedInUserName has default value as   $P{LoggedInUser}.getUsername() ) things get hay-wired

 

Y has query in following format :-

WHERE column_1 = $P{X}

And column_user_id = $P{LoggedInUserName}

 

Now when we run the report,

it still keeps on showing the previous values, the one which exist before Updating the Table’s column and only changes it after we click on the OK button after making few available selection from the parameter Y for that user.

 

So basically it seems that even though we have changed the existing value of column for  Y, for particular value of X and username it still gets saved in Jasper server some where and only gets refreshed after making few selections.

Moreover this seems to be very much user specific.Thus it seems list of parameters for user gets saved somewhere in Server.

 

This actually effects the dynamic behavior of the parameter.

 

Query for X:-

Select column_a from Table1

 

Query for Y:-

Select column_b from Table2

WHERE column_1 = $P{X}

And column_user_id = $P{LoggedInUserName}

 

Jasper Server Version:- Professional 3.7

 

Kindly advise on the same.

Regards,

Raman Deep Singh

[ramnik]

This has been Bug in JS Pro 3.7 and has been fixed too in current Release which will be available as Js Pro 3.7.1 by almost end of June. If you need it ASAP, please contact Support Service

Ramnik Kaur

Senior QA Engineer

[ramandeep1980]

Hi Ramnik,

Thank you for replying.

It would be nice if this can be confirmed by some Jasper Soft official.

 

Regards,

Raman Deep Singh

 

[ramnik]

well i myself is working in Jaspersoft and i have access to the bugs logged internally and fixed in Jasperserver

thanks

Ramnik Kaur

Senior QA Engineer

[ramandeep1980]

Oh..I was not aware of this fact about you being with Jasper Soft.

Thank you for replying...

I will contact the Jasper Soft' support Team to help me fix this bug.

 

Regards,

Raman Deep Singh