Overslaan naar inhoud
Menu
Je moet geregistreerd zijn om te kunnen communiceren met de community.
Deze vraag is gerapporteerd
3 Antwoorden
5557 Weergaven

How can i get the last record created in odoo16 ?

Avatar
Annuleer
Auteur Beste antwoord

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
Annuleer

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.

Beste antwoord

Please use the "Last updated on" filter


Avatar
Annuleer
Beste antwoord

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


Avatar
Annuleer
Gerelateerde posts Antwoorden Weergaven Activiteit
3
aug. 25
2503
1
mei 25
2585
1
apr. 25
3553
1
apr. 25
4401
1
apr. 25
1863