Merge pull request #309 from af83/5919-make-coluns-sortable

Make ReferentialVJs#index sortable. Refs #5919 

1 files changed, 2 insertions, 2 deletions

diff --git a/app/models/chouette/vehicle_journey.rb b/app/models/chouette/vehicle_journey.rb
index 4a6ba3f75..028cd18dd 100644
--- a/app/models/chouette/vehicle_journey.rb
+++ b/app/models/chouette/vehicle_journey.rb
@@ -381,8 +381,8 @@ module Chouette
     end
 
     def self.lines
-      lines_query = joins(:route).select("routes.line_id").to_sql
-      Chouette::Line.where("id IN (#{lines_query})")
+      lines_query = joins(:route).select("routes.line_id").reorder(nil).except(:group).pluck(:'routes.line_id')
+      Chouette::Line.where(id: lines_query)
     end
   end
 end