diff options
| -rw-r--r-- | app/controllers/autocomplete_lines_controller.rb | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/app/controllers/autocomplete_lines_controller.rb b/app/controllers/autocomplete_lines_controller.rb index 945736ab9..0202ea054 100644 --- a/app/controllers/autocomplete_lines_controller.rb +++ b/app/controllers/autocomplete_lines_controller.rb @@ -9,13 +9,15 @@ class AutocompleteLinesController < ChouetteController @lines = referential.line_referential.lines filter = <<~SQL - number LIKE ? - OR name LIKE ? + lines.number LIKE ? + OR lines.name LIKE ? + OR companies.name ILIKE ? SQL @lines = @lines + .joins(:company) .where( filter, - *Array.new(2, "#{params[:q]}%") + *Array.new(3, "%#{params[:q]}%") ) .search(params[:q]) .result |