Create an activity and link competency to it, and define a rule Upon activity completion: Complete the competency
if this rule is triggered, it mark competency completed.
Now we delete the activity from a course.
Go to Competency breakdown and click on the rating. You will get an error that the record does not exist in the cotext table.
Because the exporter try to get the context of the evidence (not found beacause the activity deleted)
- clean evidences linked to activity when deleted
- when getting evidence in the sql join with context table to make sure it exists