0

for a special Moodle-Workflow i need an SQL Query that tells me in which global groups (cohorts) a user with ID 100 is assigned or inserted. Who can help? Thanks a lot everyone for help.

1 Answers1

0

Assuming your database prefix is default mdl_ :

SELECT c.* FROM mdl_cohort_members cm LEFT JOIN mdl_cohorts c ON (c.id = cm.cohortid) WHERE cm.userid = 100
Evgeniy Voevodin
  • 231
  • 1
  • 6