Rails Sorting the record based on the array passed in where condition

I have got the solution of this just need to do

In product model inside product.rb file put :

 def self.order_by_ids(ids)
    order_by = ["case"]
    ids.each_with_index.map do |id, index|
      order_by << "WHEN id='#{id}' THEN #{index}"
    end
    order_by << "end"
    order(order_by.join(" "))
  end

And query will be :

products = Product.where(:id => ids).order_by_ids(ids)

Here ids will be array of id's

Simply sort by using indices of your ids array:

products = Product.where(id: ids).sort_by { |prod| ids.index(prod.id) }

Plus it's database agnostic, and it's ok to do in Ruby as you won't have millions of ids in any case.

The answer is for mysql only

There is a function in mysql called FIELD()

So you can do something like

products = Product.where(id: ids).order("field(id, #{ids.join ','})")

In Postgres

hot_offer_ids = ["7081", "7083", "6917", "5075"]
values = ''
hot_offer_ids.each_with_index do |offer_id, index|
  values += ", " if index > 0
  values += %((#{offer_id}, #{index}))
end
hot_offers = Offer.joins("join (VALUES #{values}) as x(id, ordering) on offers.id = x.id").order("x.ordering")

You can use this gem (order_as_specified) that allows you to do native SQL ordering like this:

Model.where(id: ids).order_as_specified(id: ids)

Reference Answer : Link