CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Dashboard Filter Question

edited Jul 22, 2014 12:47PM in CRM On Demand - Reports and Dashboards (MOSC) 2 commentsAnswered ✓

I have a report that shows opportunities for the current user only.  The list is long and the users want a filter based on the account.  I've created a Dashboard Prompt using the Account Name and in the Show field specify SQL Results.  If I enter the code of SELECT Account."Account Name" FROM "Opportunity Lists" WHERE Opportunity.Owner = 'Specific User Name' it works great.  But the 'Specific User Name' needs to be dependent on the current user.  I tried using a session variable and write the code like this: SELECT Account."Account Name" FROM "Opportunity Lists" WHERE Opportunity.Owner = NQ_SESSION.USER_ALIAS   but

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center