Skip to Content
This question has been flagged
5 Replies
24678 Views
Avatar
bjr

Hello everybody,

I'm on Odoo 10 and I'd like to save a computed field in database.

Firstly the field get value but in database is empty. Then I add a store=True.

The problem is that the field doesn't get value until I edit and save the field.

Can you help me to solve this problem?

Thanks.

Best regards

Avatar
Discard
Anil Kesariya

If you want to store your compute field in database, then there must be need of depends, based on which the compute function is evaluated. So whenever the values of depends field will be changed your function will executed and the value of your field will be updated. you need set store=True as attribute in field inside. @Yegendra Has given correct example to achieve your Goal.

bjr
Author

I have already put the @api.depends. However the field still empty in DB.

I think the problem in the field that I depend on it, because is already setted.

Avatar
Yogendrasinh Chavda
Best Answer

Hello boujari,

if we add "store=True" in the computing field, a method is computed and the result is stored in the database and it will not be changed.
if you want to a stored result so you must have to define store=True and Also @api.depends() relevant to compute method.
for example:
if you want to calculate age so the birth date is mandatory to calculate age, so we can set birthday as @api.depends() because as is calculate as per birthday

    @api.multi

    @api.depends('birthdate')

    def _calculate_age(self):

        for rec in self:

            if rec.birthdate:

                today = datetime.now().date()

                bdate = rec.birthdate

                today_date = str(today)

                start = datetime.strptime(today_date, '%Y-%m-%d')

                ends = datetime.strptime(bdate, '%Y-%m-%d')

                diff = relativedelta(start, ends)

             #   age = str(diff.years) + ' Years, ' + str(diff.months) + \

               #                     ' Months, ' + str(diff.days) + ' Days '

                rec.age = (diff.years)

age = fields.Integer(compute='_calculate_age', string='Age')

Thanks


Avatar
Discard
bjr
Author

Thank you for your ansewr @Yogendrasinh.

I have already put the @api.depends. However the field still empty in DB.

I think the problem in the field that I depend on it, because is already setted

Avatar
Yordan Velez Rodríguez
Best Answer

@bjr

you must use store=True in the definition of the fields:

age = fields.Integer(compute='_calculate_age', string='Age', store=True)

Avatar
Discard