[Building Sakai] How to retrieve MCQ test attempted questions and its answers using SQL query from database

[Karen Tsao]

Hi Khan,

The student's answers are saved in sam_itemgrading_t. table You can join it
with SAM_PUBLISHEDANSWER_T to get the answer texts.

>From your email, sounds like you can see the submission from database?
Maybe we can quickly check if we can make this record show up in UI? For
this record, can you check what the value of "forGrade" column in
sam_assessmentgrading_t? Does this assessment allow multiple submissions?
Are there duplicate records for this student?

Thanks,
Karen

On Mon, May 21, 2012 at 9:40 PM, Khan <vupk at yahoo.com> wrote:

> Dear All
>
> we use Sakai 2.8.0
> Oracle 9i
> Windows platform
>
>
> We conducted MCQ test of 200 students using semigo tool, one student
> result is not displaying, although his test is properly submitted.
> His teacher asking for retrieving his attempted test report (questions
> attempted and its answers) from database, I find out his aggregate score.
> But teacher asking for complete detail, I searched in database but I
> could not find any table from where I could retrieve his attempted
> questions and its answer.
>
> Any help please ?
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120522/25495e75/attachment.html