CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Dashboard Constraint

edited Nov 12, 2015 10:02AM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered

Hello,

I'm trying to constrain a dashboard prompt by a date selector, however the field I'm trying to constrain is displaying SQL results, meaning the 'Constrain' button doesn't display.

I have added default values to the constrain, however we'd like it to be dynamic based off of the first date field with the condition between.

Is this achievable within SQL results?

To confirm, first field is a date field with the condition between

Second field (The one we want to constrain) is a text field but is displaying SQL results

The reason we're using SQL results is because we're getting the word before the first '#'

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