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

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

    XMLWordPrintable

Details

    • MOODLE_26_STABLE, MOODLE_27_STABLE
    • MOODLE_26_STABLE, MOODLE_27_STABLE
    • wip-MDL-47796-master
    • 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.

    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

              abgreeve Adrian Greeve
              ademmer Tobias Ademmer
              John Okely John Okely
              Damyon Wiese Damyon Wiese
              Rajesh Taneja Rajesh Taneja
              Amaia Anabitarte, Carlos Escobedo, Laurent David, Mikel Martín Corrales, Sabina Abellan, Sara Arjona (@sarjona), David Woloszyn, Huong Nguyen, Jake Dallimore, Meirza, Michael Hawkins, Raquel Ortega, Safat Shahin, Stevani Andolo
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                10/Nov/14