about mdl_role_assignments

about mdl_role_assignments

에 Chirag Patel 씀
Number of replies: 7

hey guys I have question about mdl_roel_assignments\

That it has two lines

When you download it and open it in excel

then line 2 and 5

It shows that same user has been gievn same role 3(student).

Means same user has been given student role two times,

How that popssible?

평균 등급 : -
In reply to Chirag Patel

Re: about mdl_role_assignments

에 Paul Holden 씀
Core developers 사진 Moodle HQ 사진 Moodle Workplace team 사진 Particularly helpful Moodlers 사진 Peer reviewers 사진 Plugin developers 사진 Testers 사진

They're assigned in different contexts.

평균 등급 : -
In reply to Paul Holden

Re: about mdl_role_assignments

에 Chirag Patel 씀

Thanks after posting I realized it,but now i have another question

I am constructin one query

which gives me number of count that each student has viewed course!

can you help me with this!!!1

평균 등급 : -
In reply to Chirag Patel

Re: about mdl_role_assignments

에 David Mudrák 씀
Core developers 사진 Documentation writers 사진 Moodle HQ 사진 Particularly helpful Moodlers 사진 Peer reviewers 사진 Plugin developers 사진 Plugins guardians 사진 Testers 사진 Translators 사진
Also, IIRC the same role can be provided by multiple enrolment plugins - see the column "component".
평균 등급 : -
In reply to David Mudrák

Re: about mdl_role_assignments

에 Chirag Patel 씀

he david can you help me with ADMIN variable and its properties,Because in moodle course  it is not explained!!!I am also working on query but now i want this help!!

평균 등급 : -
In reply to Chirag Patel

Re: about mdl_role_assignments

에 Chirag Patel 씀

I want to count time spent by user in each course so in which table should i lookn for except mdl_log!!!

평균 등급 : -
In reply to David Mudrák

Re: about mdl_role_assignments

에 Blair F. 씀
Particularly helpful Moodlers 사진

I came across this post after posting my own question here:

https://moodle.org/mod/forum/discuss.php?d=329638

In my case, there are multiple rows of the same contextid and there's no component entry, at all. I don't understand.  I've got some students in a course that have 11, 12, even 15 records that all appear to have the same data.

평균 등급 : -