Home » Developer & Programmer » Reports & Discoverer » Parameterising a report based on user access
Parameterising a report based on user access [message #213381] Wed, 10 January 2007 09:01 Go to next message
Anand Ramaswamy
Messages: 111
Registered: January 2005
Senior Member
Hi All,
I have a view called viewA and I have created a folder in EUL based on this view.
I have created a worksheet based on this folder. This view has got a field called userid, can I use the login info of discoverer and supply this value as a parameter to the view so that it shows only the records pertaining to that user.

For example:
If user A logins in it should execute the view
select * from viewA where userid='A' and show the contents pertaining to user A only. Similary if user B logins it should execute select * from viewA where userid='B' and show the contents pertaining to user B only.

Is it possible to do this in discover?

Re: Parameterising a report based on user access [message #213396 is a reply to message #213381] Wed, 10 January 2007 10:07 Go to previous message
Messages: 912
Registered: March 2005
Location: Netherlands
Senior Member

Normally, you would use the Discoverer function USER, it's under the calculations, functions.

But you're working in Apps (based on your other post), so the user logged on to Discoverer is actually the Apps user (with responsibility) and not the database user (which shows when using USER). I assume you have some column like created_by_loging or updated_by_login in the table too (if it's an apps table, as I assume). You would have to compare that to the apps user logged on. There is a FND function in Apps that will do that for you (sorry, can't bring myself to looking it up right now, don't have an apps environment available), so you'll have to register that function in the EUL, make it available for the user edition and use that instead of the "regular" USER function.

Previous Topic: Slow Discoverer Reports
Next Topic: Setting Up List Of Values
Goto Forum:

Current Time: Sun Oct 23 09:37:27 CDT 2016

Total time taken to generate the page: 0.04752 seconds