diff options
| author | Xinhui | 2016-11-30 11:40:33 +0100 |
|---|---|---|
| committer | Xinhui | 2016-12-01 14:08:16 +0100 |
| commit | 1bff7526c4969aad59818d67f618cc73d15888ca (patch) | |
| tree | 6d3b3d56802ce78de82f920ceb78bc1ae80a0173 /app/controllers | |
| parent | f9963cf72299ab2bfb70da3a7fab7f64f8959b93 (diff) | |
| download | chouette-core-1bff7526c4969aad59818d67f618cc73d15888ca.tar.bz2 | |
Stop_area search is now case insensitive
Refs #2119
Diffstat (limited to 'app/controllers')
| -rw-r--r-- | app/controllers/autocomplete_stop_areas_controller.rb | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/app/controllers/autocomplete_stop_areas_controller.rb b/app/controllers/autocomplete_stop_areas_controller.rb index 1e43f3968..b653e6cb5 100644 --- a/app/controllers/autocomplete_stop_areas_controller.rb +++ b/app/controllers/autocomplete_stop_areas_controller.rb @@ -26,7 +26,8 @@ class AutocompleteStopAreasController < InheritedResources::Base else result = referential.stop_areas end - @stop_areas = result.where("name LIKE '%#{params[:q]}%' OR registration_number LIKE '%#{params[:q]}%' OR objectid LIKE '%#{params[:q]}%' ").limit(50) + args = [].tap{|arg| 3.times{arg << "%#{params[:q]}%"}} + @stop_areas = result.where("name ILIKE ? OR registration_number ILIKE ? OR objectid ILIKE ?", *args).limit(50) @stop_areas end |