diff options
| author | Xinhui | 2017-12-14 14:12:50 +0100 | 
|---|---|---|
| committer | Xinhui | 2017-12-14 14:12:50 +0100 | 
| commit | f6266458813eda31912a1b44a93a545d0a517c28 (patch) | |
| tree | fb2b303a0f7a0845123c3b748aa13847858d8f02 | |
| parent | 00f3016a5908ec52b492d7465947ff61e322c0c2 (diff) | |
| download | chouette-core-f6266458813eda31912a1b44a93a545d0a517c28.tar.bz2 | |
Autocomplete stop area, use unaccent in query search
Refs #5305
| -rw-r--r-- | app/controllers/autocomplete_stop_areas_controller.rb | 2 | 
1 files changed, 1 insertions, 1 deletions
| diff --git a/app/controllers/autocomplete_stop_areas_controller.rb b/app/controllers/autocomplete_stop_areas_controller.rb index 233012028..be1badff0 100644 --- a/app/controllers/autocomplete_stop_areas_controller.rb +++ b/app/controllers/autocomplete_stop_areas_controller.rb @@ -18,7 +18,7 @@ class AutocompleteStopAreasController < ChouetteController        scope = scope.possible_parents if relation_children?      end      args = [].tap{|arg| 4.times{arg << "%#{params[:q]}%"}} -    @stop_areas = scope.where("name ILIKE ? OR city_name ILIKE ? OR registration_number ILIKE ? OR objectid ILIKE ?", *args).limit(50) +    @stop_areas = scope.where("unaccent(name) ILIKE unaccent(?) OR unaccent(city_name) ILIKE unaccent(?) OR registration_number ILIKE ? OR objectid ILIKE ?", *args).limit(50)      @stop_areas    end | 
