[Deploying Sakai] SAMIGO Saved but not submitted answers in a survey
DAVID ROLDAN MARTINEZ
darolmar at upvnet.upv.es
Fri Jun 17 07:57:04 PDT 2011
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.
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
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.
production mailing list
production at collab.sakaiproject.org
TO UNSUBSCRIBE: send email to production-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"
More information about the production