Paginate the results of a query in Ruby on Rails

Posted on 12 May 2006

To paginate the results of a query you need to use conditions. Which can easily be combined into the default pagination built into Rails.

So you can do:

    @query = params[:query].strip
    @track_pages, @tracks = paginate(:tracks, :per_page => 10, :conditions => [ "tracks.`name` LIKE ?", "%#{@query}%"])

If you would like to query more than one table you just use :include like so:

@track_pages, @tracks = paginate(:tracks, :per_page => 20, 
                                                     :include => :artist, 
                                                     :conditions => [ "tracks.`name` LIKE ? or artists.`name` LIKE ?", "%#{@query}%", "%#{@query}%"])

View the snippets archive ››