Have been looking for way to sort foreign key records in Symfony 1.4 for few days. I’ve a staff table with a foreign key to comments. Whenever i call the StaffTable->getComments() the records return is not in alphabetical order. Finally i found some helpful tips from a forum (sorry i lost the forum url), and i manage to sort foreign key record with just a line of code. 🙂
To sort foreign key record in Symfony 1.4, follow the steps below:-
Advertisements
- Open the file lib/model/doctrine/base/BaseStaff.class.php and look for the function name ‘setUp‘ and look for this:-
$this->hasMany('Comment', array( 'local' => 'staff_id', 'foreign' => 'comment_id', 'onDelete' => 'setnull'));
Copy it and follow the next step.
- go to lib/model/doctrine/Staff.class.php
- Create a function as below:-
public function setUp() { parent::setUp(); $this->hasMany('Comment', array( 'local' => 'staff_id', 'foreign' => 'comment_id', 'orderBy' => 'created_at', 'onDelete' => 'setnull'));)); }
- Now refresh the page and you should see your record being sorted according to created_at time
Related posts:
WordPress Custom Taxonomy Pagination show 404 page not found error
How to setup mysqldump without password in cronjob
How to re-arrange account order in Thunderbird
How to loop thru directory files in bash shell
jQuery: disable autoscrolling to top when click on anchor
How to hide apache2 version number in error page
Install eAccelerator to Optimize PHP performance
How to strtolower an array in PHP?
Share this with your friends:-