Allow prompt with underlying SQL to be limited to other prompts

Marcelo Finkielsztein

Organization Name (Required - If you are an Oracle Partner, please provide the organization you are logging the idea on behalf of):

postmedia

Description (Required):

While developing dashboard prompts, when i choose “all column values” for populating a prompt i can set “limit values by” and pick other column prompts.

if i change it to “results from logical SQL”, then the UI stops offering the “limit values by” option.

please, allow column prompts to be limited by the values of other prompts, EVEN when the List-Of-Values fir this prompt comes from a SQL statement.

Use Case and Business Need (Required):

dashboard prompt with two prompts: manager and employee.

Manager column is populated with all managers where Status=‘active’

Logical SQL: select MANAGER from SALES where STATUS = ‘Active’

Employee column is populated with this Logical SQL:

select EMPLOYEE from SALES where STATUS=‘Active’

Problem: the UI does not let me limit employee values by manager. Plus there is no way to write a Logical SQL that uses the recently picked manager(s) in a where clause for the SQL that populated “Emploee”

Enhancement Request / Service Request:

none