Skip to Main Content

Dashboard Prompt Issue: SQL + Constraint

1003917Apr 18 2013

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?

Post Details