We need a query to indicate the freshness of UDP data, e.g. most recent assignment submission date, most recent quiz submission date, most recent user session time, etc. But those queries take long time to run.
The query for latest assignment submission timestamp took long time to finish: SELECT max(created_date) FROM entity.learner_activity_result
The query for latest quiz submission timestamp runs faster: select max(created_date) from entity.quiz_result qr
For now, we will use the following "latest assignment update time" query. This query runs much faster compared to above queries. NOTE: Assignment updates may be less frequent towards the end of the semester.
select max(updated_date) from entity.learner_activity
We need a query to indicate the freshness of UDP data, e.g. most recent assignment submission date, most recent quiz submission date, most recent user session time, etc. But those queries take long time to run.
SELECT max(created_date) FROM entity.learner_activity_resultselect max(created_date) from entity.quiz_result qrFor now, we will use the following "latest assignment update time" query. This query runs much faster compared to above queries. NOTE: Assignment updates may be less frequent towards the end of the semester.
select max(updated_date) from entity.learner_activityUse "Yellow" for the alert level.