Quantcast

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
|  
Report Content as Inappropriate

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
|  
Report Content as Inappropriate

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.
Loading...