[Building Sakai] samigo submitted assessments not displaying.

Yzelle, Sonette SYzelle at unisa.ac.za
Tue Apr 17 06:11:36 PDT 2012 

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,

Regarding the problem where we have 25 submissions but not all are displaying when you click on "25" (number submitted link).

The releaseto "ECH2601-12-S1".

When I use this select I get 25 records:
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;

When I use this select I get 0 records:
select *
FROM   SAM_PUBLISHEDACCESSCONTROL_T, SAM_PUBLISHEDASSESSMENT_T, SAM_ASSESSMENTGRADING_T,
       SAKAI_USER_ID_MAP
WHERE  SAM_PUBLISHEDACCESSCONTROL_T.RELEASETO LIKE ('ECH2601-12-S1')
AND    SAM_PUBLISHEDACCESSCONTROL_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;

What is the correct select to use to get the assessments?

Attached is the result set for the first select. A .csv file, delimiter ~

Thank you for your help.

Sonette


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: 02 April 2012 09:18 PM
To: Yzelle, Sonette
Cc: sakai-dev at collab.sakaiproject.org; Moller, Johann
Subject: Re: [Building Sakai] samigo submitted assessments not displaying.

Hi Sonette,

So when you change from SAM_ACCESSACCESSCONTROL_T to SAM_PUBLISHEDACCESSCONTROL_T, you got nothing return? But if you see some data from UI, that means your query is wrong. What is your value in ReleaseTo column?

And the attached data is from the previous query? If that's from SAM_ACCESSACCESSCONTROL_T, the data actually is incorrect. Can you send me the results after your modify your query?

Thanks,
Karen

On Thu, Mar 29, 2012 at 11:11 PM, 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.
________________________________

Hi Karen,

Please find attached the .csv file as requested.
Your willingness to help is really appreciated.
When I use SAM_PUBLISHEDACCESSCONTROL_T instead of SAM_ACCESSACCESSCONTROL_T then no results are returned.
A funny thing also happened, normally only 8 of the 25 displayed but today there are 11 displaying.  I don't know if the lecturer is doing something funny.
Here is the assessmentgradingids of the assessments that are not being displayed.
1529772

1529789

1529832

1529842

1529897

1530076

1530217

1530235

1530289

1530344

1530430

1530555

1530605

1531444






Sonette Yzelle
Analyst Developer
Portal and Academic Solutions
ICT
UNISA

From: ktsao at hungs.org<mailto:ktsao at hungs.org> [mailto:ktsao at hungs.org<mailto:ktsao at hungs.org>] On Behalf Of Karen Tsao
Sent: 27 March 2012 08:31 PM
To: Yzelle, Sonette
Cc: sakai-dev at collab.sakaiproject.org<mailto:sakai-dev at collab.sakaiproject.org>; Moller, Johann

Subject: Re: [Building Sakai] samigo submitted assessments not displaying.

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<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.
________________________________

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<http://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> [mailto: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<mailto: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/20120417/9ef3a71b/attachment.html

More information about the sakai-dev mailing list