#264 Incorrect counts when using rails 2.3 :having option and scopes - will_paginate library

Type	To find
responsible:me	tickets assigned to you
tagged:"@high"	tickets tagged @high
milestone:next	tickets in the upcoming milestone
state:invalid	tickets with the state invalid
created:"last week"	tickets created last week
sort:number, importance, updated	tickets sorted by #, importance or updated
Combine keywords for powerful searching.
Use advanced searching »

#264 open

Incorrect counts when using rails 2.3 :having option and scopes

Reported by Blane Dabney | March 3rd, 2009 @ 07:07 PM

I'm using rails 2.3 and have a named_scope that uses the :having option to filter results based on joined aggregate data. When using will_paginate with this, the :having (and :group) options from the scope are not passed through to the count method, so the page count it calculates is inaccurate. I have attached the patch I made to resolve this. It probably needs some work but it resolved my immediate need. It basically ensures that the :having and :group options are pulled from the scope and ONLY if they weren't explicity defined when calling paginate.

mislav-will_paginate-2.3.7_scoped_having.patch 667 Bytes

Comments and changes to this ticket

Mislav March 3rd, 2009 @ 07:10 PM
- State changed from “new” to “open”
That's a good explanation. I will look into it

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.