Union Parameters

Matt_t_t

Hello,

I have a union query that joins three tables. All three unions have the same parameter user like ? in the query. I want to be able to use the same parameter on each of the three unions. The query filters the datasets on whoever is logged into the portal. It works fine on one but not on all three together.

Sounds simple - could just link them all to one report parameter but i do not have any report parameter. I use this code in the parameter section to filter the data on who is logged on so i have no report parameters. I did try and create three of these parameters but no luck. P.s. This is in the default value of the query parameter which isnt linked to a report parameter.

var username = reportContext.getAppContext().get("ServerUserName");

if (username != null)
username + "%";
else
"%";

mwilliams

Hi Matt_t_t,

Can you attach your report design so I can see your setup? What version of BIRT are you using?