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

Jim Eng jimeng at umich.edu
Fri Jul 9 10:07:46 PDT 2010


I am thinking about 1 vs 3.  

Meanwhile, assuming you are retrieving sites from site service and then retrieving evals, here's a suggestion for item 2: 

You could set arbitrary limits on the number of sites and the number of evaluations you will work with.  You search for the sites without exceeding your arbitrary limit.  Then you search for the evals for those sites without exceeding the limits.  If either of the searches would have exceeded the limits, instead of paging, display a message at the top of the results page saying the search returned too many results to display and suggesting that the user narrow the search.  

If you were doing the join across tables (item 3), you could do paging, but again it would probably be better to narrow the search.

Just ideas.

Jim
  


On Jul 9, 2010, at 12:09 PM, Lovemore Nalube wrote:

> 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.
> 
> 
> ### 
> _______________________________________________
> evaluation mailing list
> evaluation at collab.sakaiproject.org
> http://collab.sakaiproject.org/mailman/listinfo/evaluation
> 
> TO UNSUBSCRIBE: send email to evaluation-unsubscribe at collab.sakaiproject.org with a subject of "unsubscribe"

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/evaluation/attachments/20100709/16cea303/attachment-0001.html 


More information about the evaluation mailing list