Separate Groups not working for ‘View List’ functionality in Database Activity

Separate Groups not working for ‘View List’ functionality in Database Activity

by Manoj Navalkar -
Number of replies: 6

We are using Moodle 3.6.3. In one of the courses we are using Database activity to capture data from Trainees. All Trainees are part of separate groups based on their locations along with their Mentors who are given role of Non-editing teacher. Mentor will assess entries made by Trainees from his group. At course level, we have selected ‘Separate Groups’ as a setting and enforced it to all activities.

When the Mentor accesses the database activity, he can see list of only those groups of which he is part of in the drop-down ‘Separate groups’. But in the ‘View List’ tab, he is able to view entries of Trainees from other groups as well; we confirmed that only ‘Approved entries’ from other groups are visible here. In other words, functionality of Separate Groups is not working for the ‘View List’.

However, Separate Groups functionality is working fine for the Export tab of Database activity.

Let us know how we can resolve this issue or if there is any workaround for this. Please also let us know if you require any additional input or screenshot. Thank you.
Average of ratings: -
In reply to Manoj Navalkar

Re: Separate Groups not working for ‘View List’ functionality in Database Activity

by William Lu -
Hi Manoj,

By Moodle default, Non-editing teacher (their Mentors who are given role of Non-editing teacher) can access All groups.




Could you please try this:

Inside the course, as Editing-teacher's role, click the Database activity administration > Permissions



Change 'Access all groups' from Allow to Prevent.



Good luck.
In reply to William Lu

Re: Separate Groups not working for ‘View List’ functionality in Database Activity

by Manoj Navalkar -
Hi William,

We tried the above solution, but it didn't work. Further, this functionality is working in the 'Export' Tab' . It seems that for selection of 'Approved' entries, the group filter is not working for the 'View List' tab.

Can you please guide us on this?

Let us know if we can analyse code where the filtering logic is programmed so as to try some tweaks.

Do excuse a bit of a delay; the system had gone live around the time we shared the query and there has been quite some activity on that portal.

best regards,
Manoj
In reply to Manoj Navalkar

Re: Separate Groups not working for ‘View List’ functionality in Database Activity

by William Lu -
Could you please try again by selecting the 'Prohibit' radio button?
In reply to William Lu

Re: Separate Groups not working for ‘View List’ functionality in Database Activity

by Manoj Navalkar -
Hi William, 

Selecting the Prohibit option too didnt work. Do also note that this issue is occurring even for the admin login. 
So, the 'View List' seems to include 'Approved' items across groups when showing the a particular group members with entries in the database, while the 'Export' tab logic properly excludes users who are not from other groups. 

Do advise.
Best regards,
Manoj
Attachment UsingTheProhibitOption.png
In reply to Manoj Navalkar

Re: Separate Groups not working for ‘View List’ functionality in Database Activity

by William Lu -
In this case, permissions only affect 'lower' roles, i.e non-editing teachers and students. You should remove the 'Manager, Creator and teacher', you don't need the Guest and other lower roles in the list either.

Just to double-check: Your students only see their own group, right?
If so, you can simply create the Mentor role with the 'Role archetype=Student'.
In reply to William Lu

Re: Separate Groups not working for ‘View List’ functionality in Database Activity

by Manoj Navalkar -
Hi William,
Thank you for your prompt response.
We have tried the above workaround too (creating Mentor role with 'Role archetype=Student'. However, that too hasn't resolved the issue. It is evident that the filter logic includes all users who are 'approved', irrespective of the group they are in (despite the group mode selected being 'Separate Groups'). This issue may require deeper analysis of the code and we request your support for this. I would like to request the following -
a. Take the issue offline; can I interact with you one-to-one and also engage a tech person at our end to assist in analysing this.
b. One the resolution is found, the outcome can be updated in this thread and we can close this issue.

Do let me know if that is fine?

Do excuse the delay in providing updates on this.

best regards,
Average of ratings: Useful (1)