Is there a way to identify assignments that have selected Plagiarism Review using Canvas Data?
Hi Jarrad Coots, I have found this information using the requests table. It works once originality reports have been generated, because tools using the plagiarism framework make API calls to associate them with their submissions. You can find how many originality reports have been associated with assignments using something like
SELECT assignment_id, COUNT(*) AS reports FROM requests WHERE http_method = 'POST'AND web_application_controller = 'lti/originality_reports_api'AND web_application_action = 'create'GROUP BY assignment_id ;
Because the requests table gets so large, I also insert requests with 'originality_reports' in the URL into a separate table for speedy querying.
Retrieving data ...