[Using Sakai] problems with getting back Assignment draft from databse

[Zhen Qian]

Hi, Anders:

There is currently no support to get submission data from EntityProvider.

However, you still can retrieve that from db.

1. view source from browser for the assignment list view page. Look for
"assignmentId=" indicator inside the link string for the corresponding
assignment title and copy the id. The assignment id string should have the
pattern of: /assignment/a/<SITE_ID>/<ASSIGNMENT_ID>, where the value of
<ASSIGNMENT_ID> is the primary key for assignment_assignment table in db.

2. get student id.

3. make a selection in assignment_submission table:

select * from assignment_submission where context=<assignment_id> and
submitter_id=<student_id>

But above all, why was the student draft submission disappeared?

Thanks,

- Zhen

On Thu, Mar 8, 2012 at 5:48 AM, Anders Nordkvist <anders.nordqvist at his.se>wrote:

>  Hi all,****
>
> ** **
>
> I have a question regarding Assignments. One of our students was going to
> submit an assignment but instead saved it as a draft that somehow
> disappeared. Now I don’t know how to get the draft back!****
>
> I tried to get it from the database but don’t know if its possible. I got
> this from sibmitter and submission ID:****
>
> ** **
>
> ** **
>
> /assignment/c/AU113G-20121-01/f7b15f22-029c-4884-8204-ca548e514953****
>
> ** **
>
> I have tried to put the string in a browser as an admin in Sakai but I
> don’t get it to work! Is it possible to show drafts in assignment somehow?
> ****
>
> ** **
>
> We use Sakai 2.7.x and revision 99588****
>
> ** **
>
> Regards ****
>
> Anders Nordkvist ****
>
> System administrator****
>
> University Of Skövde****
>
> Sweden****
>
> ** **
>
> _______________________________________________
> 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/20120308/55490343/attachment.html