I am trying to get the last record id with out using the create() from the ORM. Does anyone know how to get a last record id from a table? thank you
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilità
- Magazzino
- PoS
- Progetti
- MRP
La domanda è stata contrassegnata
6
Risposte
52385
Visualizzazioni
Well I finally got something working. This is what I did, I used the database cursor and wrote an sql select statement like this:
cr.execute('select "id" from "table_name" order by "id" desc limit 1')
id_returned = cr.fetchone()
the fetchone() method returns a tuple of one value which is assigned to the id_returned variable. I can then get the id from the tuple by referencing the first index like this: id_returned[0]
Not quite sure about the older versions but you can do it like this in the newer ones:
last_id = self.env['table.name'].search([])[-1].id
The ordering of the table might be such that the highest id is not equivalent to the last entry in the list. Thus I would explicitly provide the order in the search method:
last_id = self.env['table.name'].search([], order='id desc')[0].id
Answer Andreas is good.
If you don't want to execute PSQL query then you can search the record and get the max number, eg.
search_ids = self.pool.get("res.partner").search(cr, uid, [])
last_id = search_ids and max(search_ids)
The sequencing is also stored in the database and can be retrieved with a statement like:
select * from res_partner_id_seq
you can use something like this :
max(model('helpdesk.ticket').search([]))
the solution like the above does not work. It returns the id of the last one in the search() method, but the ids are not sorted. The last id should not be the max one.
last_id = self.env['table.name'].search([])[-1].id
Ti stai godendo la conversazione? Non leggere soltanto, partecipa anche tu!
Crea un account oggi per scoprire funzionalità esclusive ed entrare a far parte della nostra fantastica community!
Registrati| Post correlati | Risposte | Visualizzazioni | Attività | |
|---|---|---|---|---|
|
2
giu 16
|
3976 | ||
|
3
gen 16
|
5394 | ||
|
0
giu 24
|
2035 | ||
|
2
ago 23
|
3064 | ||
|
1
ott 22
|
7142 |
Maybe with SELECT max(id) FROM table