[Building Sakai] samigo submitted assessments not displaying.

[Karen Tsao]

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>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] *On Behalf Of *Karen Tsao
> *Sent:* 27 March 2012 08:31 PM
> *To:* Yzelle, Sonette
> *Cc:* 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>
> 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/20120402/031746c2/attachment.html