You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Error while creating Prompt using free SQL

edited Dec 12, 2022 8:42AM in Taleo Learn

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 and

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!