I wrote a small pagination example a while back, the link is http://wiltonsoftware.com/posts/view/custom-group-by-pagination-and-a-calculated-field.
I used the function for 3 paginated views, since I only had one of the paginated views using the group by clause I just checked for that condition. Possibly you could add some other condition logic if needed, haven't tried that though. Hope that helps. On Wed, Jan 28, 2009 at 1:42 AM, jst4fun <[email protected]> wrote: > > Hello All, > I want to create a pagination in which the data is grouped using group > by clause. I think cake php pagination do not support group by > directly and instead we need to do it using custom pagination method. > I saw the documentation for it in the book, but the issue is that I > only want the group by in one action and lot of other actions depend > on the same model. So my doubt is if I override paginate() and > paginateCount() wont that affect all the other pagination which > depends on the same action. If yes is there any other methods to use > group by clause with pagination? Thanks > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
