[Building Sakai] Samigo submitted flag help

[Karen Tsao]

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 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> 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
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> 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/8bc39333/attachment.html