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
Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!
About This Community
|Asked: 11/16/13, 9:42 AM|
|Seen: 944 times|
|Last updated: 3/16/15, 8:10 AM|