Display the sum of a field of a model that has a many2many relationship with its parent, in the parent table view

Question

Hi,
I am working on an agricultural project and have one model that represents all the zones where I have planted a crop and a second model that represents daily harvests data, connected by a many2many relationship.
The idea being that every day, an employee on each zone harvests the crop and inputs the amount harvested for that day in that zone.
When displaying the Zones in a table, I would like to see the sum of all the harvested amounts for that zone (i.e. the sum of the Kg_Harvested field in

Paresh Wagh · Answer

You will need to define a computed field in the Zones model that calculates the sum of the Kg_Harvested field in the x_harvests model corresponding to that record.

相關帖文	回覆	瀏覽次數
get the sum of a field's value in a relation of many2many with another model many2many sum Odoo13.0	2 9月 21	8600
Where are stored each line of a many2many field in the database? 已解決 database values many2many table	1 2月 16	10738
ODOO V16 Associate Parts to a Finished Good many2many	1 2月 24	1952
Custom Model Data in Many2many field without storing in Database many2many	0 7月 24	2985
Why a new record is creating when selecting in Many2Many field many2many	0 7月 22	60

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！