How can I use
cus = self.env['res.partner'].search([('id', ...
to find the highest id in the table res.partner ?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Księgowość
- Zapasy
- PoS
- Project
- MRP
To pytanie dostało ostrzeżenie
3
Odpowiedzi
17829
Widoki
Billiard,
You can use:
self.env['res.partner'].search([ ], order="id desc" limit="1")
here order helps to get the id in descending order and limit helps you to fetch the no of records you want to fetch.. i kept 1 to fetch the highest/final id
Hope it helps you
self.env['res.partner'].search([ ], order="id desc", limit=1)
all_records_sorted_by_id = self.env['res.partner'].search([ ]).sorted(key = lambda rec: rec.id, reverse=True)
if all_records_sorted_by_id:
highest_id = all_records_sorted_by_id[0].id
Now I get this error: TypeError: sorted() got an unexpected keyword argument 'reverse'
you should not receive this error if you write clean v8.0 code and "self" is a recordset in the above code (because of "self.env" used in the code, I assumed that it is v8, but it seems you mix v7/v8 styles and self is not a recordset here as you got this error... ) . see the definition of "sorted" function: "Odoo 8.0"/openerp/models.py#L5450 you can see that "sorted" function has the "reverse" keyword argument in it's definition. Anyway, @Pawan provided better solution (it avoids to turn around all partners list, so more suitable solution especially in case of large quantity of partners), but this one should work as well in a clean v8.0 API code.
Podoba Ci się ta dyskusja? Dołącz do niej!
Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!
Zarejestruj się| Powiązane posty | Odpowiedzi | Widoki | Czynność | |
|---|---|---|---|---|
|
2
paź 15
|
9081 | ||
|
1
mar 22
|
3045 | ||
|
What is 'better': search or browse?
Rozwiązane
|
|
1
gru 23
|
20962 | |
|
[SOLVED] New API Search/Browse - how?
Rozwiązane
|
|
6
mar 24
|
37322 | |
|
2
mar 15
|
17807 |
