Re: Paginate and Order

Have you tried sorting with a virtual field using pagination? As far
as I know, virtual fields are sortable using pagination... both from
experience and according to
http://book.cakephp.org/view/1608/Virtual-fields

Modifying definitely does create problems(unless it is a bugfix that
you submit, which is adopted by the dev team).... it causes issues in
upgrading, especially if another programmer ends up working on your
project.

On Sep 26, 7:45 am, Sanza <mass...@creativebrains.it> wrote:
> Hi at all,
> sorry for my english but I think that this probably can to be useful
> for everybody, maybe this little update can to be committed but I
> don't know how and where to make this...
> I use Mysql and Cake 1.3.x
>
> I has a problem to order some field using o normal paginate on views.
> With simply queries its works perfectly but when we create 'virtual'
> colums like, for example:
>
> CONCAT(name,' ', surname) AS complete_name
>
> Or using a sub query to calculate a column like:
>
> ( SELECT COUNT(*) FROM recipes WHERE recipes.some_field =
> main_table.id) AS number_recipes
>
> and so on, when we set a column name that not exist in the table
> schema, the paginate method of controller class don't add this:
>
> ORDER BY complete_name
>
> For this i have added a little "else" on this file /cake/libs/
> controller/controller.php line 1145.
>
> The orginal code was:
>
> f ($object->hasField($field)) {
>         $options['order'][$alias . '.' . $field] = $value;} elseif ($object->hasField($field, true)) {
>
>         $options['order'][$field] = $value;} elseif (isset($object->{$alias}) && $object->{$alias}-
> >hasField($field)) {
>
>         $options['order'][$alias . '.' . $field] = $value;
>
> }
>
> The code modified is:
>
> f ($object->hasField($field)) {
>         $options['order'][$alias . '.' . $field] = $value;} elseif ($object->hasField($field, true)) {
>
>         $options['order'][$field] = $value;} elseif (isset($object->{$alias}) && $object->{$alias}-
> >hasField($field)) {
>
>         $options['order'][$alias . '.' . $field] = $value;} else {
>
>         $options['order'][$field] = $value;
>
> }
>
> Maybe this change can create other kind of problem that I don't
> consider for this I would like to have a expert opinion from the
> community!
> Massimo

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en