[Contrib: Evaluation System] Searching evaluations by sakai site name

[Lovemore Nalube]

Hi
 
We are interested in searching course evaluations by a site title and getting paged results using the administrative search feature in trunk and RC. However, it's proving to be a head scratcher.
 
The basic idea would be to search for matching sites, filter the evaluation assign groups that match on the id and then filter out the evaluations. There are several ways to do this and each presents another set of problems. These are the ways;
Retrieving the site matches using the sakai site service: means that the database is hit twice. First for the site ids and then for the evaluations using the evaluations DAO. Also paging becomes difficult to implement since not all sites will contain evaluations.
Avoid paging: this will solve the paging problem, but is not scalable.
Use one query for everything: Cross query the sakai tables and evaluation tables using joins. This is not proper practice.
Any ideas?
 
 
 
 
--
Lovemore Nalube
OLE Developer (Vula)
University of Cape Town
http://www.cet.uct.ac.za/LovemoreN



 

###
UNIVERSITY OF CAPE TOWN 

This e-mail is subject to the UCT ICT policies and e-mail disclaimer published on our website at http://www.uct.ac.za/about/policies/emaildisclaimer/ or obtainable from +27 21 650 4500. This e-mail is intended only for the person(s) to whom it is addressed. If the e-mail has reached you in error, please notify the author. If you are not the intended recipient of the e-mail you may not use, disclose, copy, redirect or print the content. If this e-mail is not related to the business of UCT it is sent by the sender in the sender's individual capacity.

###
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/evaluation/attachments/20100709/1de12886/attachment.html