paginate not working when using .order()

[fabOnReact]

I also tried this with Kaminari and it has the same problem. My current solution is caching the total result in the frontend and performing the pagination on that data in the frontend mobile app.

This is the solution written in React

class Locations extends Component {
   componentDidMount() {
    this._setData() 
  }

  componentDidUpdate(prevProps, prevState) {
   // const next_page ...
   if(next_page) { this._setLocations() }
  }

  _setData = async () => {
    const request =  await this.api.getLocations({ flags: ["with_cameras=true"] })
    const locations = await request.json()
    this.setState({ data: locations })
  }

  get begin() {
    const { page } = this.state
    return page * 2
  }

  get end () {
    return this.begin + 2
  }

  _setLocations = async () => {
    const { data } = this.state
    const { loaded } = this.props
    const locations = data.slice(this.begin, this.end)
    this.setState({ locations })
    loaded
  }
}

I have the following Location model

class Location < ApplicationRecord
  has_many :cameras
  has_many :posts, through: :cameras
  scope :with_posts, -> { includes(cameras: :posts).where(cameras: { posts: { flagged: false }}) }
  scope :newest, -> { order(last_camera_at: :desc) }
  scope :newest_cameras, -> { order('cameras.last_post_at DESC') }
  scope :newest_posts, -> { order('posts.created_at DESC') }
end

pagination does not work

locations = Location.with_posts.newest.newest_cameras.newest_posts.paginate(page: 2, per_page: 2)
locations.size 
=> 2
locations.first.name 
=> "Dreamland"
locations = Location.with_posts.newest.newest_cameras.newest_posts.paginate(page: 3, per_page: 2)
locations.size 
=> 1
locations.first.name 
=> "Dreamland"

There is only 1 locations named "Dreamland" with multiple posts. The query returns a unique set of locations with their associated data, but will_paginate does not work after ordering the query.

associated issues
#573
#553

thanks a lot

[mislav]

Sorry you're having trouble! See https://github.com/mislav/will_paginate/wiki#limitations