Odoo Help

0

Openerp sorting char to float

js
By
Prakash
on 11/16/13, 9:42 AM 1,122 views

In openerp 7 char data type float value stored. In list view sorting value how to change the char to float ?

In SQL Editor the below code is used:-

select char_value from cvw_patientintake order by cast(char_value as float) asc

select char_value from cvw_patientintake order by cast(char_value as float) desc

The above code how to apply in openerp custom module overriden search function is any sample code available?

Thanks in advance

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.

Register

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

0 follower(s)

Stats

Asked: 11/16/13, 9:42 AM
Seen: 1122 times
Last updated: 3/16/15, 8:10 AM