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

              • Votes:
                0 Vote for this issue
                Watchers:
                5 Start watching this issue

                Dates

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