Tuesday, September 2, 2014

Re: Paginate Sort on columns from related tables

you will need to use something like http://github.com/lorenzo/linkable to make that work

You add the behavior to the models: $actsAs = ['Linkable.Linkable'];

Then in your Paginator options you can add:

$this->Paginator->settings['link'] = ['Patient' => ['CareGiver']];

This will probably help you getting the models in the same query so you can sort by them.

On Thursday, August 28, 2014 3:54:01 PM UTC+2, John Sposato wrote:
We are having some issues getting this to work, is it possible?

For example,

We have a Patient model with a HABTM relationship to CareGiver.  And a PatientCase model that belongs to Patient with the hasMany to it from Patient.  Both HABTM relationships are setup and are correct.  

On the patient_cases index, we are trying to sort on some CareGiver columns, but it's not working.  It seems to sort, but not by those columns.  Is going from PatientCase->Patient->CareGiver too far for Paginate to sort columns?

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP

---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.

No comments: