Forum Stats

  • 3,874,206 Users
  • 2,266,682 Discussions
  • 7,911,769 Comments

Discussions

Dashboard Prompt Issue: SQL + Constraint

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
This discussion has been closed.