aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorXinhui2017-12-14 14:12:50 +0100
committerXinhui2017-12-14 14:12:50 +0100
commitf6266458813eda31912a1b44a93a545d0a517c28 (patch)
treefb2b303a0f7a0845123c3b748aa13847858d8f02
parent00f3016a5908ec52b492d7465947ff61e322c0c2 (diff)
downloadchouette-core-f6266458813eda31912a1b44a93a545d0a517c28.tar.bz2
Autocomplete stop area, use unaccent in query search
Refs #5305
-rw-r--r--app/controllers/autocomplete_stop_areas_controller.rb2
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