Will_paginate

Rails
1

paginate :per_page => 15, :page => page,
:conditions => [‘title like ?’, “%#{search}%”], :order
=> ‘requirement_id DESC, created_at DESC’

In my table:
requirement_id/created_at
1/5am
1/3am
2/5pm
2/3pm

How can I specify to only return the first row in each requirement_id
group? That is, I only want to paginate 1/3am and 2/3pm because 1/3am is
the first row in the group requirement_id = 1…

Thanks!

2

Justin To wrote:

paginate :per_page => 15, :page => page,
:conditions => [‘title like ?’, “%#{search}%”], :order
=> ‘requirement_id DESC, created_at DESC’

I’ve been reading around and I think a solution may be to use the SQL
‘limit 1’, but where do I stick this in?