Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
3 Odpovědi
5500 Zobrazení

How can i get the last record created in odoo16 ?

Avatar
Zrušit
Autor Nejlepší odpověď

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
Zrušit

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.

Nejlepší odpověď

Please use the "Last updated on" filter


Avatar
Zrušit
Nejlepší odpověď

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


Avatar
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
3
srp 25
2317
1
kvě 25
2545
1
dub 25
3515
1
dub 25
4344
1
dub 25
1820