Ruby on Rails order by id (and version?)

Asked 2012-06-15T19:58:56.877

While trying to search with id sorting (and paginating) im getting from the log:

SELECT `audits`.* FROM `audits` ORDER BY version, id DESC LIMIT 50 OFFSET 0

I am currently using this code:

@records = Audit.order("id DESC").page(page).per(50)

The problem is that the list retrieved is not correctly sorted by id descending.

BTW i am using audited-activerecord gem for audits, does this matter?

Edit Report

1 Answer

I'm guessing that your gem is setting a default scope on the Audit model that orders by version, so at the moment it is ordering in ascending order by the version column, and, only if two records are the same, is it ordering by id in descending order.

To fix this, you can prepend unscoped to your chain:

Audit.unscoped.order("id DESC").page(page).per(50)

answered 2012-06-15T20:11:32.717

Ruby on Rails order by id (and version?)

1 Answer

Your Answer