[Building Sakai] Samigo submitted flag help

[Wheat, Jon]

Thank you, all set now.
I'm saving those queries :)


From: Karen Tsao <ktsao at stanford.edu<mailto:ktsao at stanford.edu>>
Date: Mon, 5 Dec 2011 12:18:58 -0800
To: Jonathan Wheat <jwheat at messiah.edu<mailto:jwheat at messiah.edu>>
Cc: SAKAI Dev <sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>>
Subject: Re: [Building Sakai] Samigo submitted flag help

Hi Jon,

The table is SAM_ASSESSMENTGRADING_T. You can first run the following query to get the two submissions:

select assessmentgradingid, forgrade from sam_assessmentgrading_t ag, sam_publishedassessment_t pa
where pa.title = :assessment_title and ag.publishedassessmentid = pa.id<http://pa.id> and agentid = :student_id

You should see two records with forgrade equals to "false". And then run the following update to flip it to "true".

update sam_assessmentgrading_t set forgrade = true where assessmentgradingid in (:assessment_grading_id_1, :assessment_grading_id_2)

Thanks,
Karen


On Mon, Dec 5, 2011 at 7:58 AM, Wheat, Jon <jwheat at messiah.edu<mailto:jwheat at messiah.edu>> wrote:
So Sakai crashed over the weekend, and of course 2 students were in the middle of a mid term exam.
The prof did the 1 question per page (thankfully) so I know the answers up until that point are in the db.

Can someone point me in the right direction (there's quite a few SAM_ tables in there) to find the data I need to flip that flag so the prof can at least view the answers that were completed?

Thanks,
 -Jon


_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>
http://collab.sakaiproject.org/mailman/listinfo/sakai-dev

TO UNSUBSCRIBE: send email to sakai-dev-unsubscribe at collab.sakaiproject.org<mailto:sakai-dev-unsubscribe at collab.sakaiproject.org> with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20111205/1a41c365/attachment.html