CODEWITHSUNDEEP
model-view-controllersql-order-bycakephp-2.0recursive-query
Jonline
Jonline

Reputation: 1747

Cakephp 2.0: How to provide ORDER BY instructions for data retrieved recursively through find()?

I am trying to set up a model with a lot of hasMany/hasOne relationships, and I'd like for the owned models to be presented, alphabetically, in a drop-down menu within the "Add" view. I am not sure how to provide ORER BY instructions to models that are retrieved recursively. This is what I've tried:

$services =  $this->service->find('all', array(
                                       'order'=>array(
                                               'Service.start_year DESC',
                                               'Servicecat.title DESC'
                                               ), 
                                        'recursive'=>0
                                          ) );

But of course this yields no change. I have a suspicion it's not very complicated, I just can't find a solution in the cookbook/api. Ideas?

Upvotes: 1

Views: 9804

Answers (1)

Scott Harwell
Scott Harwell

Reputation: 7465

You could do this a few ways. I prefer to use the containable behavior for models and then it allows you to finely control how the models are retrieved. You could also setup order in your model's relationship definition.

Model Way

$hasMany = array(
    'Servicecat' => array(
        'order' => array(
            'Servicecat.title DESC'
        )
    )
);

Containable Way

In your models, set them to use the containable behavior:

public $actsAs = array('Containable');

Then, when you find from your controller, you can explicitly state which models are linked. You can use multidimensional arrays to determine the depth of recursion.

$services = $this->Service->find(
    'all',
    array(
        'contains' => array(
             'Servicecat' => array(
                 'order' => array('Servicecat.title' => 'DESC')
             )
         ),
         'order' => array('Services.start_year' => 'DESC')
    )
);

Upvotes: 5

Related Questions