How to operate a field depending on the stage?

Question

In proyects, in every task i have a "total float field", and i need to sum the totals of tasks and render it in the project view, but only the tasks that are in the stage "To do".
this is my code, but is not working.
@api.depends('tasks.sum_total_cost')
def todo_sum(self):
todo = self.env['project.task'].search([('stage_id', '=', 'To Do')])
for task in todo:
task.sum_todo= round(sum(task.mapped('sum_total_cost')), 2)

Kevin Cruz · Accepted Answer

You just need to apply the sum after filtering with the correct path.
Try this

@api.depends('tasks.sum_total_cost')
def todo_sum(self):
todo = self.env['project.task'].search([('stage_id', '=', 'To Do')])
for data in todo:
if data:
self.sum_todo = round(sum(todo.mapped('sum_total_cost')), 2)

Verknüpfte Beiträge	Antworten	Ansichten
Create Journal Entries whit code Gelöst python odoo12	2 Aug. 25	6403
Two many2many fields related to each other inside one model Gelöst python odoo12	1 Juni 22	8388
how to make invoice date field readonly false for administrator after validating invoice in odoo12? python odoo12	1 Sept. 21	3246
Update tax in invoice line python odoo12	0 Aug. 21	95
How do I find Average Cost Function? python odoo12	0 Juli 21	172

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!