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

All responses result orders not always intuitive

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.5
    • Fix Version/s: 2.5.1
    • Component/s: Module: Questionnaire
    • Labels:
      None
    • Plugin Version:
      2013093001
    • Affected Branches:
      MOODLE_25_STABLE
    • Fixed Branches:
      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

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

              Dates

              Created:
              Updated:
              Resolved:
              Fix Release Date:
              8/Jul/13