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

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

by William Lu -
Number of replies: 5
Picture of Particularly helpful Moodlers
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.
Average of ratings: -
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
Average of ratings: -
In reply to Manoj Navalkar

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

by William Lu -
Picture of Particularly helpful Moodlers
Could you please try again by selecting the 'Prohibit' radio button?
Average of ratings: -
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
Average of ratings: -
In reply to Manoj Navalkar

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

by William Lu -
Picture of Particularly helpful Moodlers
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'.
Average of ratings: -
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)