Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-47796

Database module: mixed up entries in separate groups mode for teachers

    XMLWordPrintable

    Details

    • Testing Instructions:
      Hide
      1. Make sure you have a course with students and teachers enrolled and at least two groups.
      2. Create a database activity. Make sure that the groups are set to 'separate'
      3. Create a couple of fields and save the templates.
      4. Log in as a few different students and create some entries.
      5. Log on as a teacher and switch between the different groups. Make sure that the entries are related to the correct group.
      6. Try setting the settings for the database activity to visible groups.
      7. Check again that the correct records are being shown for each group.
      Show
      Make sure you have a course with students and teachers enrolled and at least two groups. Create a database activity. Make sure that the groups are set to 'separate' Create a couple of fields and save the templates. Log in as a few different students and create some entries. Log on as a teacher and switch between the different groups. Make sure that the entries are related to the correct group. Try setting the settings for the database activity to visible groups. Check again that the correct records are being shown for each group.
    • Affected Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Fixed Branches:
      MOODLE_26_STABLE, MOODLE_27_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      wip-MDL-47796-master

      Description

      There is an issue with the database activity (mod data) using separate groups for any role with editing rights in a course (teacher, admin, ...) .

      Following scenario:
      1. Database activity is set up in mode "separate groups"
      2. Database fields are set up to upload files
      3. Students are assigned to groups
      4. Students upload files into the database activity within their assigned group

      From a student perspective everything works fine and each group is only able to see files uploaded within their own group.
      For a teacher role, there is a problem with the displayed entries per group:

      Selecting "All participants" or any of the groups in the "list view" results in a list of random entries being shown from diverse groups. Switching from one group to the next leads to different more or less random results.

      To reproduce:
      1. Create a course with a teacher and at least two groups A and B (assign a demo student to each group )
      2. Create a database activity in separate groups mode and add a new field (e.g. file)
      3. Set up list view
      4. Let each student add an entry to the database for his/her group
      5. Log in as teacher, open the list view of the database and select group B in the drop down menu -> all files are shown, not only those of group B
      6. Select "All participants" -> only file of group B is shown

        Attachments

        1. Image1.png
          Image1.png
          31 kB
        2. Image2.png
          Image2.png
          14 kB
        3. Image3.png
          Image3.png
          23 kB

          Issue Links

            Activity

              People

              Assignee:
              abgreeve Adrian Greeve
              Reporter:
              ademmer Tobias Ademmer
              Peer reviewer:
              John Okely
              Integrator:
              Damyon Wiese
              Tester:
              Rajesh Taneja
              Participants:
              Component watchers:
              Adrian Greeve, Jake Dallimore, Mathew May, Mihail Geshoski, Peter Dias, Andrew Nicols, Jun Pataleta, Michael Hawkins, Shamim Rezaie, Simey Lameze
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Fix Release Date:
                10/Nov/14