Odoo Help


How to sort a many2one field in descending order

on 5/22/14, 12:48 PM 5,229 views

Hello, I was wondering if there is an easy way to sort a many2one field in descending order?  Is it in the python file or xml view?  I tried adding an _order = 'field_name desc' in the python class file, but it didnt work.  Thank you 

Johan Van Houtvinck
On 8/10/17, 5:35 AM

_order = 'field_name desc' in the model should normally work but it applies for all views of your application
If you want to specify the order only in that many2one field, one solution is to use a context value and overwrite the search function:


In my python class:
    period_id = fields.Many2one(string='Period',

In my XML view
    <field name="period_id"  context="{'order_display': 'name desc' }"/>

In the python model of the comodel:
    class AccountPeriod(models.Model):
        _inherit = 'account.period'
        def search(self, args, offset=0, limit=None, order=None, count=False):
            ctx = self._context
            if 'order_display' in ctx:
                order = ctx['order_display']
            res = super(AccountPeriod, self).search(
                args, offset=offset, limit=limit, order=order, count=count)
            return res




| 5 5 7
Bikaner, India

OpenERP Developer at SunARC Technology

On 5/24/14, 2:44 PM

To add your code in the many2one master table in the python file for the name fields or other fields that are using to display value in the drop down list

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

2 follower(s)


Asked: 5/22/14, 12:48 PM
Seen: 5229 times
Last updated: 8/10/17, 5:35 AM