[Building Sakai] samigo submitted assessments not displaying.

[Yzelle, Sonette]

This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Hi Karin,

Thank you for your feedback.

The assessment is not released to multiple sections and the students are still valid users.

Here are the queries and the results (attached) that I got from the database:
select *
FROM   SAM_ASSESSACCESSCONTROL_T, SAM_PUBLISHEDASSESSMENT_T, SAM_ASSESSMENTGRADING_T,
       SAKAI_USER_ID_MAP
WHERE  SAM_ASSESSACCESSCONTROL_T.RELEASETO LIKE ('ECH2601-12-S1')
AND    SAM_ASSESSACCESSCONTROL_T.ASSESSMENTID = SAM_PUBLISHEDASSESSMENT_T.ASSESSMENTID
AND    SAM_ASSESSMENTGRADING_T.PUBLISHEDASSESSMENTID = SAM_PUBLISHEDASSESSMENT_T.ID
AND    SAM_ASSESSMENTGRADING_T.SUBMITTEDDATE IS NOT NULL
AND    SAM_ASSESSMENTGRADING_T.AGENTID IS NOT NULL
AND    SAM_ASSESSMENTGRADING_T.STATUS = 1
AND    SAM_ASSESSMENTGRADING_T.AGENTID = SAKAI_USER_ID_MAP.USER_ID
ORDER BY SAM_ASSESSMENTGRADING_T.ASSESSMENTGRADINGID, SAM_ASSESSMENTGRADING_T.AGENTID;


Sonette Yzelle
Analyst Developer
Portal and Academic Solutions
ICT
UNISA

From: ktsao at hungs.org [mailto:ktsao at hungs.org] On Behalf Of Karen Tsao
Sent: 23 March 2012 06:56 PM
To: Yzelle, Sonette
Cc: sakai-dev at collab.sakaiproject.org
Subject: Re: [Building Sakai] samigo submitted assessments not displaying.

Hi Sonette,

Is this assessment released to multiple sections? Are these 17 students still valid users? If you already queried db, can you send me the results?

Thanks,
Karen


On Fri, Mar 23, 2012 at 6:31 AM, Yzelle, Sonette <SYzelle at unisa.ac.za<mailto:SYzelle at unisa.ac.za>> wrote:
This message (and attachments) is subject to restrictions and a disclaimer. Please refer to http://www.unisa.ac.za/disclaimer for full details.
________________________________

Good day,

I am Sonette from Unisa and we on Sakai 2.8 (Samigo -2.8.0)

We have a case where there are 25 submitted assessments. When the lecturer clicks on the "25" only 8 submissions are displayed.
Any idea why this is happening?  I can see the submissions in the database. I don't know if there is maybe a setting somewhere that will stop a submission from displaying?

Your help will be appreciated.

Regards
Sonette

Sonette Yzelle
Analyst Developer
Portal and Academic Solutions
ICT
UNISA


_______________________________________________
sakai-dev mailing list
sakai-dev at collab.sakaiproject.org<mailto: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<mailto: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/20120326/9651e5a2/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: samigo_results
Type: application/octet-stream
Size: 452446 bytes
Desc: samigo_results
Url : http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20120326/9651e5a2/attachment.obj