MainelyDesign.com Blog

Sorting Paginated Results Using a Related Model Field in CakePHP

Posted on 02/06/2011 at 10:12 pm by Kevin Wentworth
Viewed 18,404 times | 0 comments

Time crunch, so this will be quick.  I didn't want to go hunting for how to sort paginated results in CakePHP using a related model field again.  I actually found my answer on Stack Overflow.  The original poster had it right, so I'm not sure if it was a CakePHP bug or what (I don't have an account or I would correct it... it's on the list of to-dos though).

Using a Related Model Field To Sort Paginated Results

  1. <th><?php echo $paginator->sort('title'); ?></th>
  2. <th><?php echo $paginator->sort('code'); ?></th>
  3. <th><?php echo $paginator->sort('Location', 'AvjobsLocation.name'); ?></th>

Notice how that last one is just a little different... just specify the related model, followed by the field to sort on.... duh!

 

Cheers,

-Kevin Wentworth

Bookmark and Share

Tags for Sorting Paginated Results Using a Related Model Field in CakePHP

Cakephp | Web Programming | Usage | Example

Comments for this Posting

No comments. Be the first to post a reply.

Sorry, comments are closed for this posting.

Please Email Kevin if you have any questions. Thanks!

Meet Site Avenger - Hosted Content Management System

Powered By: Site Avenger | Site Production: Saco Design