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

818 views Asked by At

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!

1

There are 1 answers

1
OldWest On BEST ANSWER

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.