ActiveRecord order by array of strings [duplicate]

Question

If I have an array such as: ['Apple','Orange','Pear']

How could I retrieve records from a model by implementing a "custom sort"? For example, what if I want to sort the fruit_type column by Orange, Pear, and then Apple?

Not trying to sort alphabetically or numerically, but just based on a custom order that I'm looking for.

You have a two options, 1. Custom indexing(position) like Eyeslandic mentioned, or 2. Custom algorithm )) — 7urkm3n
– 7urkm3n, Commented Aug 5, 2019 at 15:10

Eyeslandic · Accepted Answer · 2019-08-05 14:14:13Z

0

The best way I think would be to create a new table with something like

create_table :fruit_types do |t|
  t.string  :name
  t.integer :sort_order
  # .....
end

Then use that in your model

# model.rb
belongs_to :fruit_type

Then query with

Model.joins(:fruit_type).order('fruit_types.sort_order')

answered Aug 5, 2019 at 14:14

Eyeslandic

14.9k13 gold badges44 silver badges55 bronze badges

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

Collectives™ on Stack Overflow

ActiveRecord order by array of strings [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related