Is it possible to combine will_paginate with find_by_sql?
Use paginate_by_sql
, i.e.
sql = " SELECT *
FROM users
WHERE created_at >= ?
ORDER BY created_at DESC "
@users = User.paginate_by_sql(
[sql, 2.weeks.ago],
page: @page,
per_page: @per_page
)
As a general rule any finder can be paginated by replacing the find*
with paginate*
.