Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Query to Fetch withdrawn assignments in Learning — Cloud Customer Connect
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

Query to Fetch withdrawn assignments in Learning

Received Response
1
Views
1
Comments
in Reporting and Analytics for HCM 1 comment

Summary: I am trying to fetch the learners who got withdrawn from the courses in Learning.

Content (required): We discover that thousands of learning assignment records have been withdrawn from the various trainings in Learning for the last few months. So, to see the impacted records, wanted to build the report using BI Publisher, and tried with one Person number but ended up with duplicate rows.

FYI: The specific person does have only one withdrawn record from the UI Learning, whereas from the attached SQL query, getting the same record more than five times.


Version (include the version you are using, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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