Moodle

improve sql in overview report for fetching question grades

Details

  • Type: Sub-task Sub-task
  • Status: Closed Closed
  • Priority: Minor Minor
  • Resolution: Fixed
  • Affects Version/s: 1.9
  • Fix Version/s: 1.9.2
  • Component/s: Quiz
  • Labels:
    None
  • Affected Branches:
    MOODLE_19_STABLE
  • Fixed Branches:
    MOODLE_19_STABLE

Description

SQL for fetching detailed question marks is a seperate query than main query to fetch attempts. But there is a kind of a hack to be able to sort attempts by question grade. Simplified code by moving all querying for question grades into main attempts sql query.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Ann Adamcik added a comment -

This change has introduced a regression when there are more than 29 questions in the quiz. Please see MDL-15092 for details.

Show
Ann Adamcik added a comment - This change has introduced a regression when there are more than 29 questions in the quiz. Please see MDL-15092 for details.
Hide
Permalink
Jamie Pratt added a comment -

Closing this although another bug has come up as a result of this fix.

Show
Jamie Pratt added a comment - Closing this although another bug has come up as a result of this fix.
Hide
Permalink
Dongsheng Cai added a comment -

Close, see another bug: MDL-15092

Show
Dongsheng Cai added a comment - Close, see another bug: MDL-15092

People

Vote (0)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved:
Atlassian JIRA (v4.4.5#665-sha1:422aead) | Report a problem
Powered by a free Atlassian JIRA open source license for Moodle. Try JIRA - bug tracking software for your team.