Rails - Query table with array of IDs and order based on the array

Question

Let me describe with simple example.

I have a list of numbers:

ex: list = [ 3, 1, 2 ]

and I have a table in DB named Products which have 3 rows with product_id = 1, 2and 3.

Now I need to query Products sort by list values (3,1,2) so the result will be:

product_3 product_1 product_2

Query will be like: product.sort(list) or product.order(list) or some other alternative pls

jeffdill2 · Accepted Answer · 2016-03-05 21:07:42Z

1

This should work for you:

list = [3, 1, 2]

Product.where(product_id: list).sort_by { |p| list.find_index(p.product_id) })

answered Mar 5, 2016 at 21:07

jeffdill2

4,1442 gold badges32 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1