[Building Sakai] Searching for a user by their full name (KNL-691)

[Steve Swinsburg]

I have attached a revised patch to the issue which completes this functionality. I have also posted a screenshot of it working and an audit of the other tools affected by this patch (only one tool in the entire codebase including indies, and that's the Users tool).

>> https://jira.sakaiproject.org/browse/KNL-691

Please take a look and post in JIRA any queries.

This is required for Profile2 to be able to search properly so I'd like to be able to resolve it as soon as possible.

regards,
Steve


On 20/03/2011, at 12:25 AM, Steve Swinsburg wrote:

> Update: I've attached a preliminary patch to https://jira.sakaiproject.org/browse/KNL-691
> 
> This allows full name searches, at least from profile2. There are other kernel methods that need to be touched for it to work in the Users tool (countSearchUsers for one.\.
> 
> cheers,
> Steve
> 
> On 19/03/2011, at 11:34 PM, Steve Swinsburg wrote:
> 
>> Hi all,
>> 
>> Presently it is not possible to search for a user by their full name due to the way the SQL queries are structured. So a search for 'Sakai' will find the user, and a search for 'Administrator' will find the user, but a search for 'Sakai Administrator' will find nothing.
>> 
>> This is a long standing issue. I have reported this as:
>> https://jira.sakaiproject.org/browse/KNL-691
>> 
>> A possible and very simple solution is to split the search string on whitespace and then perform multiple searches for each term, combining the lists and removing duplicates. This is trivial to implement but I wanted to gather some feedback from the community about this and other possible fixes.
>> 
>> Thoughts?
>> 
>> cheers,
>> Steve
> 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://collab.sakaiproject.org/pipermail/sakai-dev/attachments/20110326/b178479f/attachment.html