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

SQL to get the activity completion status of learners.

Hi,

We have a requirement to get the activity completion status of each learners. In our set up a offering can have multiple activities, a learner might have completed few activities and other activities has not started. Here is the Navigation from UI Offerings>Learners>Manage Activities


Here I want to fetch Completion Date, Completion Status, Actual Effort. Below is the query I tried , but it gives the setup information of activities, how can I link it with learners and get the status of each activities?

SELECT WLFT.name "Activity Name"
, WLFI.LEARNING_ITEM_NUMBER "Activity Number"
, WLFI.start_date

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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