Query to Fetch withdrawn assignments in Learning
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):