Instructors view for self assigned course

Topics: Developer Forum, Project Management Forum, User Forum
Jul 5, 2012 at 6:02 AM

Hi,

I ddnt find this question discussed earlier. My problem is the users in the Learners group can self assign courses. Is there any way to the Instructors to view the self assigned courses by Learners. Like wat are the courses each learner assigned and wats the status of that courses(In progress, submited, etc..)

Thanks.

 

Jul 24, 2012 at 10:51 AM
Edited Jul 24, 2012 at 10:52 AM

You must create your own web part (for example in microsoft visual studio 2010) which will return data from slk tables.
Look this:

select * from dbo.AssignmentItem asi  
left join LearnerAssignmentItem lai 
on lai.AssignmentId = asi.Id 
left join AttemptStatus ats  
on ats.Id = lai.NonELearningStatus 
left join AttemptItem ati  
on ati.LearnerAssignmentId = lai.Id and ati.RootActivityId = asi.RootActivityId 
left join SuccessStatus ss 
on ss.Id = ati.SuccessStatus  
left join CompletionStatus cs  
on cs.Id = ati.CompletionStatus 
left join UserItem ui on ui.Id = lai.LearnerId

in table AssignmentItem we have column CreatedBy (this is instructor or learner, which is self assigned the course) and in table UserItem we have - Id (this is learner).