The groups and groupings for a database activity are not working as suspected. If you follow the instructions below, entries created by one user will not be displayed as you would expect.

1. Create a course with a few students and a database activity (with the common module settings for groups, etc left as the defaults)

2. Autocreate 2 groups (E.g. Group A and Group B) in under a grouping within the course

3. In the course settings set group mode to “Visible Groups”, force group mode to “Yes” and “default grouping” to the grouping just created

4. Login as one of the students (e.g. from Group A) and post some data to the database

5. When you now switch the visible group in the database to Group B it shows the posts of the Group A student. If you then go back to Group A, it doesn’t show them (if you go to all participants and then back to Group A it does show them). This is whilst still logged in as the student.

If you go back into the database activity settings and set the groupings in there it resolves the issue.