CD2 Identify if a assignment grade is visible to student

Question

Hi all,

I am trying to figure out how to identify if an assignment grade is visible to a student (posted) using CD2 data.

The submissions table workflow state only has a 'graded' state but that doesn't identify if it is available to students.

Any help will be much appreciated!

Thanks 🙂

ESheta · Accepted Answer

I typically use the posted_at field in the submissions table to determine if a grade has been posted. If the field is null, it means the grade hasn't been posted yet. If there's a timestamp value, that indicates when the grade was released to the student.

For example:

SELECT * FROM submissions WHERE posted_at IS NOT NULL AND assignment_id = '';

This query returns all submissions for the specified assignment where the grade has been posted.