Dashboard Filter Question
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