For more information, please refer to this announcement explaining best practices for getting answers to questions.
Error while creating Prompt using free SQL
Summary
I am trying to create prompt for Learning Item name using "Workforce Learning - Learning Management Real Time" subject area. I want to filter active courses andContent
I am trying to create prompt for Learning Item name using "Workforce Learning - Learning Management Real Time" subject area. I want my prompt to list only active Learning Item names, Learning Item type = 'Course' and also want to exclude some Learning Item name from prompt selection.
I want to use below SQL
----------------------------------------------
SELECT "Workforce Learning - Learning Management Real Time"."Learning Items"."Learning Item Name" FROM "Workforce Learning - Learning Management Real Time" WHERE (("Learning Items"."Learning Item Name" NOT IN ('Leader on Duty Assessment (2017)', 'Tier I: Print Certification Knowledge Assessment', 'Tier II: Print Certification Knowledge Assessment', 'Services Sales Manager Assessment', 'Tech Tier I Assessment', 'Print Sampling Assessment')) AND ("Learning Items"."Learning Item Status" = 'Active') AND ("Learning Item Type"."Name" = 'Course') ) ORDER BY 1