Skip to Content
This question has been flagged
many2manycomputed
2 Respostes
3847 Vistes
Avatar
loay elhaj

Hello everyone,

i created stored computed field that get total value based on lines and some conditions the compute function work well, but when remove the line the computed field value not deleted.

any idea ? 

function code:

@api.depends('res_id', 'res_id.consumption_rate', 'res_id.resource_type')
def get_total_values(self):
hour_values = []
ton_values = []
for line in self.res_id:
if line.consumption == 'hour':
hour_values.append(line.consumption_rate)
print(hour_values)
self.total_per_hour_cost = sum(hour_values)
else:
if line.consumption == 'ton':
ton_values.append(line.consumption_rate)
print(ton_values)
self.total_per_ton_cost = sum(ton_values)

Avatar
Descartar
Avatar
Malay Khamar (Serpent Consulting Services Pvt. Ltd.)
Best Answer

Hi Loay eIhaj,

Initially, Please try to set default value for the functional field in the function method.
Like :

@api.depends('res_id', 'res_id.consumption_rate', 'res_id.resource_type')
def get_total_values(self):
    hour_values = []
    ton_values = []
    self.total_per_hour_cost = 0.0
    self.total_per_ton_cost = 0.0
    for line in self.res_id:
        if line.consumption == 'hour':
            hour_values.append(line.consumption_rate)
            print(hour_values)
            self.total_per_hour_cost = sum(hour_values)
        else:
            if line.consumption == 'ton':
                ton_values.append(line.consumption_rate)
                print(ton_values)
                self.total_per_ton_cost = sum(ton_values)



Hope it will help you. Please Up vote.
Avatar
Descartar
Avatar
Karan BK
Best Answer

If you are creating a stored computed field, make sure you have given depends so that when dependent field is changed, value will be recomputed. Also provide your code snippet as well so it's easier to understand the problem rather than guess what might have gone wrong.

Avatar
Descartar
loay elhaj
Autor

function code:

@api.depends('res_id', 'res_id.consumption_rate', 'res_id.resource_type')
def get_total_values(self):
hour_values = []
ton_values = []
for line in self.res_id:
if line.consumption == 'hour':
hour_values.append(line.consumption_rate)
print(hour_values)
self.total_per_hour_cost = sum(hour_values)
else:
if line.consumption == 'ton':
ton_values.append(line.consumption_rate)
print(ton_values)
self.total_per_ton_cost = sum(ton_values)

Related Posts Respostes Vistes Activitat
Computed many2many field dependencies in Odoo 10
many2many computed
Avatar
1
de des. 16
8008
How do I make a button invisible if field (m2m) is False? Solved
many2many computed odoo10
Avatar
Avatar
4
de febr. 20
4240
ODOO V16 Associate Parts to a Finished Good
many2many
Avatar
Avatar
1
de febr. 24
2009
Prevent record creation in computed One2Many or Mayn2Many in Tree/Kanban field
readonly many2many inverse computed
Avatar
Avatar
2
d’abr. 24
2160
Custom Model Data in Many2many field without storing in Database
many2many
Avatar
0
de jul. 24
3066