org / group search is case sensitive

[tobes]

Please make this not so. Makes the search confusing and unusable until you discover why it's not just working.

If this is difficult to fix, then we need to add some text to say 'search is case sensitive'

[tobes]

diff --git a/ckan/logic/action/get.py b/ckan/logic/action/get.py
index 46ff233..b1240a9 100644
--- a/ckan/logic/action/get.py
+++ b/ckan/logic/action/get.py
@@ -334,9 +334,9 @@ def _group_or_org_list(context, data_dict, is_org=False):
     if q:
         q = u'%{0}%'.format(q)
         query = query.filter(_or_(
-            model.GroupRevision.name.like(q),
-            model.GroupRevision.title.like(q),
-            model.GroupRevision.description.like(q),
+            model.GroupRevision.name.ilike(q),
+            model.GroupRevision.title.ilike(q),
+            model.GroupRevision.description.ilike(q),
         ))

this is an easy fix but sqlite will choke

[shevski]

Ok thanks, who is the right person to do this? We need it at lease for geodatagov extension

[tobes]

@shevski this is a work in progress as it breaks sqlite. We could use in an emergency but we need to do things properly. So that is just a comment

[tobes]

@shevski I've changed this from ux to bug. the ux is fine it just doesn't do what is wanted :)

[tobes]

@kindly can we get this into master and the dg branch. Also I think a 2.0 backport does no harm and is a simple change

[amercader]

@tobes This sounds like something worth fixing for 2.0. Can you do a backport if it is easy? I get conflicts merging this particular commit

[tobes]

@amercader I'll do a specific 2.0 fix for you

[tobes]

@amercader this is not valid for 2.0 as there is no group/org search that is 2.1 only