[Building Sakai] samigo submitted assessments not displaying.

[Karen Tsao]

Hi Sonette,

Is it possible for you to export your result in .csv format. It's kind of
hard for me to read your result because your result contain lots
information. Also, can you please let me know couple of IDs that can and
cannot be viewed?

By the way, please use SAM_PUBLISHEDACCESSCONTROL_T instead of
SAM_ACCESSACCESSCONTROL_T in your query. Although I don't think this make
any difference in this case.

Thanks,
Karen


On Mon, Mar 26, 2012 at 1:07 AM, Yzelle, Sonette <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.
>  ------------------------------
>
>  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>
> 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
> http://collab.sakaiproject.org/mailman/listinfo/sakai-dev
>
> TO UNSUBSCRIBE: send email to
> 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/20120327/aa620037/attachment.html