OTBI Query to Retrieve the Most Up To Date Record of a Learners Learning Assignment

marcfromhawaii

I have been having issues with trying to pull the most up to date learning assignments for people for a report.

I have been using WLF_ASSIGNMENT_RECORDS_F and it is all date effective. I'm trying to find completed courses but always find duplicates in report because there is too many factors that deems an assignment record "completed". Ex; withdrawn, reassigned, auto completed, etc.

Is there a table/view or a even a simple way to add to my query conditions to find the most recent learning assignment?

marcfromhawaii

Just found

WLF_ALL_ASSIGNMENTS_V

after posting, will see if this sufficient for me