Using limit and offset in addition to page

[echan00]

@document_texts = Texts.where(active: true).reorder(created_at: :asc).limit(x).offset(y).page(params[:page])

I would like to offset my records and then limit the total number of records that can be shown with something similar to the above query. Would anybody have suggestions?

[ruurd]

Well that probably is not going to work that way because kaminari uses OFFSET and LIMIT to do its magic. However if you know the limit and offset you want you are able to calculate the page number. Then the following will get you what you need:

p = (y / x) + 1 # pages start at 1
@document_texts = Texts.where(active: true).reorder(created_at: :asc).page(p).per(x)

Note that this works best if offset is a mulitple of limit.

BTW all of this can be found in the wiki.