find order by closest to number

Question

How can I arrange order in Model.where(...).order() to sort the items based on proximity of a number field to assign number?

So, when I request to order for 4, (1...6) would be something like this: [4,5,3,6,2,1]

How do you decide whether 5 or 3 comes first? – David Aldridge Apr 20 '15 at 18:29 — David Aldridge, Apr 20 '15 at 18:29

score 4 · Accepted Answer · answered Apr 20 '15 at 18:21

4

Sounds like you want the absolute value of the difference between a given number and the field value. For example:

User.order("abs(4 - <your-field-name-here>)")

answered Apr 20 '15 at 18:21

Matt Eddy

1 Answers1