sort on array read

Question

In my controller I have

var $uses = array('User','Customer');

then I am using read to call the users

$loggedOutCustomer = $this->User->read(null, $this->Auth->user('id'));

this gives me users and cutsomers that I can use but I want to do a sort on customers name. How can i do that in cake?

Please tag only the version you are using. And what is the relationship between User and Customer? — JohnP
– JohnP, Commented May 11, 2011 at 17:27

JohnP · Accepted Answer · 2011-05-12 08:07:59Z

2

You can set the default order in your User model.

If Customer belongsTo User, User hasMany Customer.

In your User model, under the hasMany variable, find the Customer record and add Customer.name to the order array key.

Also, please remove the cakephp version tag that you are not using.

You can also add your sorting options when you're using the find() method of your model.

This can also be defined in the pagination array

Another option would be to use the Containable behavior

edited May 12, 2011 at 8:07

answered May 11, 2011 at 17:34

JohnP

50k13 gold badges112 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Oerd Over a year ago

Is there a solution if he wants to order by a different key in another place in his code? I.e. there should be a way to pass an order parameter..

JohnP Over a year ago

@oerd yup, he can define it in the find() call or on the pagination (paginate) array. He can also use the Containable behavior. Which is recommended

Oerd Over a year ago

I think you should put these comments in the answer :-)

Wil · Accepted Answer · 2011-05-12 17:46:12Z

1

Give this a try

$loggedOutCustomer = $this->User->find('first', array('conditions' => array('User.id' => $this->Auth->user('id')), 'order' => 'Customer.name ASC'));

answered May 12, 2011 at 17:46

Wil

5401 gold badge4 silver badges9 bronze badges

Collectives™ on Stack Overflow

sort on array read

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related