Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
3 Replies
5495 Tampilan

How can i get the last record created in odoo16 ?

Avatar
Buang
Penulis Jawaban Terbai

To get the last record created in Odoo 16, you can use the search() and browse() methods of the corresponding model. Here is an example of how you can do this:

partner_ids = env['res.partner'].search([], order="create_date desc", limit=1)

last_partner = partner_model.browse(partner_ids) # You can now access the fields of the last created partner record

print(last_partner.name)

print(last_partner.email) # etc.

In the code above, we first get a reference to the res.partner model using the env object. Then we use the search() method to find the ID of the last record created, using the order parameter to sort the records by create_date in descending order. We also set a limit of 1 to make sure we only get the last record. We then use the browse() method to retrieve the actual record based on its ID. Finally, we can access the fields of the last created record using the corresponding attributes of the last_partner object.


Avatar
Buang

sorry, but i failed to understand what is ' partner_model ' in second line of the solution? i want to search last record in approval.request. please help.

Jawaban Terbai

Please use the "Last updated on" filter


Avatar
Buang
Jawaban Terbai

First try to find using Group by option, then if got multiple Records in Same date then Filter on Last Created On 


Avatar
Buang
Post Terkait Replies Tampilan Aktivitas
3
Agu 25
2308
1
Mei 25
2541
1
Apr 25
3512
1
Apr 25
4343
1
Apr 25
1818