Sod will_paginate library

Comments and changes to this ticket

• 

  Mislav December 11th, 2008 @ 11:45 PM

  • State changed from “new” to “open”

  That's rather unfortunate.

  Does this help?

  
  Model.paginate :page => 1, :per_page => 10,
    :group => 'foo', :count => { :group => nil }
  

  That will cause the count to be performed like the :group option wasn't even there.

• You flagged this item as spam.
  

  Michael Ragalie December 12th, 2008 @ 12:57 AM

  That worked like a charm. All I did was use

  
  Model.paginate :page => 1, :per_page => 10, :group => 'foo.id', :count => {:group => nil, :select => "DISTINCT foo.id"}
  

  and got the expected behavior.

  Thanks for your help!

• 

  Mislav December 12th, 2008 @ 02:22 AM

  • State changed from “open” to “resolved”

  No prob ;)

• You flagged this item as spam.
  

  Sebastian February 6th, 2009 @ 12:12 AM

  I*m sorry. But I think this is absolutly wrong, and will return wrong results.

  When you group something by a specific value, and then count without the group option as described above you'll get the count of all ungrouped results.

  I don't know about a better workaround to speed things up.

• 

  Mislav February 6th, 2009 @ 01:32 AM

  You may be right.

  But still, little can be done from will_paginate. Maybe you guys should open a Rails ticket? On the other hand, the internal implementation of OrderedHash was rewritten and now the problem may be gone (better check to be sure)