Search code examples
sortingcakephppaginator

Use $this->Paginator->sort sort by a field not in the related model

I want to use $this->Paginator->sort to generate a link, but sorted by a field not in the current table, which related to this table. So can I do that? and how to do that?

Thanks so much!

Solution

  • For an external field on sort, you can do so like: 

    <th><?php echo $this->Paginator->sort('ExternalModelName', 'ExternalModelName.fieldname'); ?></th>

    But the model relationship must also be correct. So assuming your relationship is setup correctly, the above will work.