Odoo Help


How to sort a character field which contains integer values?

on 6/2/14, 3:13 AM 1,492 views

I have a character field named employee's id. In which we enter the employee id's like 102,103,1021,..,because it is a character field it shows like 102,1021,103,.. But i want to display like 102,103,1021,... How can i sort the charcter field.?




| 5 4 7
Bikaner, India

OpenERP Developer at SunARC Technology

On 6/2/14, 3:36 AM

The below SQL to Sort character field as int,

select *  from table_name order by cast(employees_id as int) asc

But in python the same code _order = "cast(employees_id as int) asc"  is not support.

Solution to override _generate_order_by method in python,

def _generate_order_by(self, order_spec, query):
        my_order = "cast(employees_id as int) asc"            
        if order_spec:
            return super(class_name, self)._generate_order_by(order_spec, query) + ", " + my_order
        return " order by " + my_order

Refer the link for more details.


Can we update it in xml code?

on 6/2/14, 3:59 AM

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

1 follower(s)


Asked: 6/2/14, 3:13 AM
Seen: 1492 times
Last updated: 3/16/15, 8:10 AM