Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Dashboard Prompt Issue: SQL + Constraint

1003917Apr 18 2013
Hello,

I have 1 dashboard prompt: Procedure room"."Room name" which I am constraining by another prompt: "Procedure room"."Department name"

Constraining works fine but the problems is that when I constrain the prompt: Procedure room"."Room name" I can no longer filter the check box values with the following SQL query:
SELECT "Procedure room"."Room name" FROM "Request - Procedure" WHERE ("Procedure room"."Inactive since" IS NULL) ORDER BY UPPER("Procedure room"."Room name" )

Any advice to solve this or workarounds?

Thanks,
Gunnar

Comments

Locked Post
New comments cannot be posted to this locked post.