Prompt filtering based on another prompt

Summary:

Hi,

I have 2 prompts as presentation variables and I need them to connect between each other. For example when I selected a specific country on the first filter, the second one should only bring courses of that specific country.

Content (please ensure you mask any confidential information):

Hi,

I have 2 prompts as presentation variables.

The first one is COURSE_COUNTRY:

and the SQL statement is the following:

SELECT "Workforce Learning - Learning Management Real Time"."Course Specific Details"."WLF_LI_COURSE_DESC_COUNTRY_"

 FROM "Workforce Learning - Learning Management Real Time"     

 where "Workforce Learning - Learning Management Real Time"."Course Specific Details"."WLF_LI_COURSE_DESC_COUNTRY_" is not null