Obtain current user for Birt report

On 6/7/2010 7:23 AM, adamcoulthard wrote:

I would like to construct a BIRT report that uses the current signed
on user as part of the birt query. I've not been able to find the
solution so far. Does anyone have any ideas how to do this?

Thanks

Adam

Here's a trick for you.

Create a data source on REPORTS_SNAPSHOT, and a data set on the
VARIABLES "table". Pass in the string '{Current Contributor}' as the
key, and select the same column as the result. This is a magic view that
takes one of our special variables as input and returns the result to
you. If I'm not mistaken the result in this case should be the UUID of
the contributor, which can then be looked up in the contributor table.

james
RTC Reports Team Lead

On 6/7/2010 7:23 AM, adamcoulthard wrote:

I would like to construct a BIRT report that uses the current signed
on user as part of the birt query. I've not been able to find the
solution so far. Does anyone have any ideas how to do this?

Thanks

Adam

Here's a trick for you.

Create a data source on REPORTS_SNAPSHOT, and a data set on the
VARIABLES "table". Pass in the string '{Current Contributor}' as the
key, and select the same column as the result. This is a magic view that
takes one of our special variables as input and returns the result to
you. If I'm not mistaken the result in this case should be the UUID of
the contributor, which can then be looked up in the contributor table.

james
RTC Reports Team Lead

Hi James,

Thanks for the tip that is brilliant, works like a charm :-).

Adam

I was super pleased to see this. I want to do something very similar (perhaps the same and I've just missed it).

I've got a report that is taking the userid as a parameter (selected from a dynamically generated listsbox populated with CONTRIBUTOR_USERID). This works correctly.

I'd love for the default value of the parameter to be the current users ID.

I'd be eternally grateful to anyone who could nudge me in the right direction.