[Deploying Sakai] SAMIGO Saved but not submitted answers in a survey

[DAVID ROLDAN MARTINEZ]

First get the published assessment id:
SELECT pa.id FROM sam_authzdata_t a, sakai_site s, sam_publishedassessment_t pa
where a.agentid = s.site_id
and functionid = 'GRADE_PUBLISHED_ASSESSMENT'
and a.qualifierid = pa.id
and s.title = :site_title
and pa.title = :assessment_title

Get the assessment grading information:
SELECT * from sam_assessmentgrading_t ag WHERE ag.publishedassessmentid = :above_id

I guess you will see the FORGRADE column has 0 (false) value. You can try to change that to 1 (true) and see if the answers show back fine.

Hope this helps.

David
________________________________________
De: production-bounces at collab.sakaiproject.org [production-bounces at collab.sakaiproject.org] En nombre de Tom Hall [thall at brocku.ca]
Enviado el: viernes, 17 de junio de 2011 15:49
Para: sakai-dev Developers; production at collab.sakaiproject.org
Asunto: [Deploying Sakai] SAMIGO Saved but not submitted answers in a survey

Hi everyone

We have a site where a number of survey respondents did not hit the
'Submit' button so their responses are still in the saved state after
the survey has closed.

Does anyone have a suggestion on how to find these saved responses and
change them to submitted.

Thanks

Tom
_______________________________________________
production mailing list
production at collab.sakaiproject.org
http://collab.sakaiproject.org/mailman/listinfo/production

TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"