Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
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.
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') Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
1
dic 16
|
8379 | ||
|
1
ott 20
|
3319 | ||
|
|
1
set 20
|
4321 | ||
|
1
dic 19
|
6827 | ||
|
0
mar 15
|
4342 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
