Inconsistencies in user submission attempts (new quizzes) across tables and interface

[Pete5484]

Looking for any insight as to why my CD2 submissions table and API submissions are returning an 'attempt' number that is different from CD2 submissions_version and from the New Quizzes moderate page.

Also, extra attempts are always NULL even after attempts are added via New Quizzes moderate (possibly related to New Quizzes not yet being in CD2). It's unclear to me from the docs what submission_versions.version_id refers to! 

e.g. the CD2 submissions indicates 11 attempts for a student and so does the API, but the submissions version table shows 12 records, and the moderate quiz page shows only 4 attempts. 

Any insights appreciated!

[stimme]

@Pete5484 I think that the discrepancies you noticed must be explained by the fact that New Quizzes is a separate application, not part of Canvas itself. The assignment submission records that New Quizzes connect with are updated via LTI. That might be why the count of attempts from the submissions table is higher that makes sense.

I haven't worked with the submission_versions table, but it looks like the version_id value is a foreign key to a table in the actual Canvas database that isn't currently part of CD2. So it is inscrutable.

New Quizzes is the next data set that should be coming to CD2. That should provide more informative and meaningful information about New Quizzes than what we can try to surmise from the submissions table.

[ESheta]

What I understand is submission_versions table, Each row here represents a version of a submission (like autosave, manual save, or final submission). So if a student edits answers multiple times before submitting, you can see more versions than actual attempts.

Moderate Page (New Quizzes): This shows actual graded attempts for the quiz, not intermediate saves.

So if a student started a quiz and saved multiple times, CD2 will show more versions than the Moderate page.
regarding to the attempt 11, I beleive when new quizzes data became available on CD2, we will find an explaination for this number. But uptill now, the number you see in the GUI on the moderate page is the actual number of student attempts.