Sorting paginated data by string length in cakephp 3.x

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Sorting paginated data by string length in cakephp 3.x

jakubplus
Hi,

I'd like to use Paginator sorting function, but for sorting by string length like mysql LENGTH(title)

$this->Paginator->sort('title')

How to do that in cakephp 3?

--
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 [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.
Reply | Threaded
Open this post in threaded view
|

Re: Sorting paginated data by string length in cakephp 3.x

euromark
using 3.x virtual fields, expr() func() 
see the docs for that

Mark


Am Sonntag, 7. Februar 2016 17:48:33 UTC+1 schrieb jakubplus:
Hi,

I'd like to use Paginator sorting function, but for sorting by string length like mysql LENGTH(title)

$this->Paginator->sort('title')

How to do that in cakephp 3?

--
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 [hidden email].
To post to this group, send email to [hidden email].
Visit this group at https://groups.google.com/group/cake-php.
For more options, visit https://groups.google.com/d/optout.