How to get the last record id from existing table

Question

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

Eric · Accepted Answer

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]

thompsonn · Answer

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

Atul Makwana · Answer

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)

Rich Granata · Answer

The sequencing is also stored in the database and can be retrieved with a statement like:
select * from res_partner_id_seq

Olivier DUCROT · Answer

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

Bài viết liên quan	Trả lời	Lượt xem
In Report module when we create own Footer giving error record	2 thg 6 16	3208
(Odoo 8) Access rights to project.task record	3 thg 1 16	4529
How to record a beta version of my website ? record website	0 thg 6 24	1442
Is Voice recording possible? in V16 Đã xử lý record odoo16features	2 thg 8 23	2431
Record rule doesn´t remove Form Edit Button Đã xử lý rule record	1 thg 10 22	6420

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!