Skip to Content
This question has been flagged
searchorderdescendingodooV13
1 Respondre
3257 Vistes
Avatar
Arian Shariat

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.
Avatar
Descartar
Avatar
Rimvydas Kanapka
Best 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')
Avatar
Descartar
Related Posts Respostes Vistes Activitat
How to use search method and order the result descending order in Odoo 8.0?
search order descending
Avatar
Avatar
1
de des. 16
8780
OdooV13 Add create an order to customer portal
sale portal order portal-user odooV13
Avatar
Avatar
1
d’oct. 20
3653
Odoo13 override validate action method Solved
stock validate inventory order odooV13
Avatar
Avatar
1
de set. 20
4644
Getting lowest and higher date of one2many records Solved
python date search order odoo12
Avatar
1
de des. 19
7140
Advanced Search by Delivery Address / Invoice Address
address quote search order advanced
Avatar
0
de març 15
4691