OdooV13 use order attr of search method with string field which contains integer

Question

I created custom field 'A' for sale.order table. field 'A' is defined as String in db. A values are numbers most of the time (eg. 50011) and sometimes default strings(eg. 'default'). I want to get top 10 A field numbers in a query. I wrote:
`recent_orders = request.env['sale.order'].sudo().search(
[('...')],
limit=10,
order='A desc')`
but it compares A data as strings. How can I make it compare them as integers and ignore string fields.

Rimvydas Kanapka · Accepted Answer

If default string is always 'default', you could try writing SQL query with cast function which converts value to your specified type:
result = self._cr.execute('select * from sale_order where A != 'default' order by cast(A as integer) desc limit 10')

相關帖文	回覆	瀏覽次數
How to use search method and order the result descending order in Odoo 8.0? search order descending	1 12月 16	8677
OdooV13 Add create an order to customer portal sale portal order portal-user odooV13	1 10月 20	3543
Odoo13 override validate action method 已解決 stock validate inventory order odooV13	1 9月 20	4533
Getting lowest and higher date of one2many records 已解決 python date search order odoo12	1 12月 19	7036
Advanced Search by Delivery Address / Invoice Address address quote search order advanced	0 3月 15	4604

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！