[Building Sakai] Report # of published assessments

[Karen Tsao]

Hi Dorie,

You would like to run a query similar to this:

SELECT * FROM sam_authzdata_t a, sakai_site s, sam_publishedassessment_t pa
where a.agentid = s.site_id
and a.functionid = 'GRADE_PUBLISHED_ASSESSMENT'
and a.qualifierid = pa.id
and s.title = :site_title
and pa.title in (:assessment_title_1, :assessment_title_2,...)

Thanks,
Karen

On Mon, Dec 13, 2010 at 8:01 AM, Doreen Minich <DMinich at messiah.edu> wrote:

>  Good Morning,
>
> I'm working on a request to generate a list of courses/professors that used
> the Tests & Quizzes tool in their course during this past semester.  I can
> find the courses and the published assessments, but I missing the link
> between assessments and courses.  Would someone like to pass along the
> tables/fields I need to query so I can match the published assessment to a
> course?
>
> TIA,
> Dorie
>
> _______________________________________________
> 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/20101213/6ae09f7d/attachment.html