method

in_order_of

v7.0.0 - Show latest stable - Class: ActiveRecord::QueryMethods

in_order_of(column, values)

public

Allows to specify an order by a specific set of values. Depending on your adapter this will either use a CASE statement or a built-in function.

User.in_order_of(:id, [1, 5, 3])
# SELECT "users".* FROM "users" ORDER BY FIELD("users"."id", 1, 5, 3)

# File activerecord/lib/active_record/relation/query_methods.rb, line 429
    def in_order_of(column, values)
      klass.disallow_raw_sql!([column], permit: connection.column_name_with_order_matcher)

      references = column_references([column])
      self.references_values |= references unless references.empty?

      values = values.map { |value| type_caster.type_cast_for_database(column, value) }
      column = order_column(column.to_s) if column.is_a?(Symbol)

      spawn.order!(connection.field_ordered_value(column, values))
    end

in_order_of

Related methods