CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Help with SQL expression on Report Prompts

edited May 24, 2013 7:12AM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered ✓
Hello,

I am using Opportunity Team Subject area to build a report with a prompt on User name. I would like to create a subset of users avialble to choose. Can someone help me wiuth the syntax for SQL exp. I am building the promt on the Alias field.

Select "Opportunity Employee".Alias FROM Owned By User where "Opportunity Employee".Division = "Utilities"

Thanks

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