Uploaded image for project: 'Plugins'
  1. Plugins
  2. CONTRIB-4750

All responses result orders not always intuitive

    XMLWordPrintable

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 2.5
    • 2.5.1
    • Module: Questionnaire
    • None
    • 2013093001
    • MOODLE_25_STABLE
    • MOODLE_25_STABLE

    Description

      View all responses - Summary

      A questionnaire instance a user has submitted the questionnaire 8 times; in 5 of these submissions text was added to a text box question.

      As Manager in the Summary, responses are listed together with respondent names, as expected. In the summary response the responses for this account are not listed in the order of submission.

      I think this is because the get_response_text_results() orders by name. Where there are multiple responses for the same name MySQL will always use ID to order from, but Postgres does what it feels like.

      We should all an extra ORDER BY condition for time submitted.

      This probably affects other question types, not just text.

      Attachments

        Activity

          People

            rezeau Joseph Rézeau
            jenny-gray Jenny Gray
            Mike Churchward
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:
              8/Jul/13