Skip to Content
Menu
This question has been flagged
3 Replies
5482 Views

How can i get the last record created in odoo16 ?

Avatar
Discard
Author Best Answer

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
Discard

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.

Best Answer

Please use the "Last updated on" filter


Avatar
Discard
Best Answer

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


Avatar
Discard
Related Posts Replies Views Activity
3
Aug 25
2224
1
May 25
2505
1
Apr 25
3496
1
Apr 25
4323
1
Apr 25
1799