[Using Sakai] Gradebook database relations

[Steve Swinsburg]

I think Gregory wanted it via SQL. That said you should be able to follow through those methods to get the SQL required, or use that info to look at the tables and determine what you need.
Note that in gb_gradebook_t the gradebook_uid is the site Id.

cheers,
Steve

On 03/09/2012, at 2:07 AM, Mark J. Norton <markjnorton at earthlink.net> wrote:

> As it happens, I just did this very thing.
> Get an instance of the GradebookService either via injection or using the ComponentManager.
> GradebookService.getViewableAssignmentsForCurrentUser(String gradebookUid) gets a list of Assignments.
> For each assignment:
> Assignment.getName();
> Assignment.getId();
> GradebookService.getAssignmentScoreString(courseId, assignmentId, userId);
> - Mark Norton
> 
> PS.  Technical questions like this one are better asked on sakai-dev.
> 
> On 9/2/2012 12:04 AM, Gregory Guthrie wrote:
>> Can anyone give me a quick hint on how to find a gradebook associated with a course, and then the graded items in the gradebook?
>> I found many of the key relations, but could not yet connect to a course.
>>  
>> I am trying to replicate the “assignments/grade report/download spreadsheet” data by a database query.
>>  
>> Is there a query in the source code somewhere I should look at for this?
>>  
>> -------------------------------------------
>> 
>>  
>> 
>> 
>> _______________________________________________
>> sakai-user mailing list
>> sakai-user at collab.sakaiproject.org
>> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
>> 
>> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
> 
> _______________________________________________
> sakai-user mailing list
> sakai-user at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/sakai-user
> 
> TO UNSUBSCRIBE: send email to sakai-user-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-user/attachments/20120903/873f4700/attachment.html