Ir al contenido
Se marcó esta pregunta
pythoncustomcompute
1 Responder
5121 Vistas
Avatar
Sam F

i have 2 fields, one we will pick a date, i would like the other to automatically compute -5 weeks from the selected date. i have played with the compute field in studio but have had no luck getting anything to work.

so far i have:


for record in self:

  record[("x_studio_field_CgBpj")] = record.x_studio_field_47ZJc - datetime.timedelta(weeks=+5)

Avatar
Descartar
Avatar
DHA Medic
Mejor respuesta

Odoo 11, Python 3.5

from datetime import datetime, timedelta
from odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT

class Test(models.Model):
    _name = "dhac.rad.project"

    test1 = fields.Datetime(string="Date Time A")
    test2 = fields.Datetime(string="Date Time B", compute="dp_test1")

    @api.depends('test1')
    def dp_test1(self):
        if self.test1:
            raw = datetime.strptime(self.test1, DEFAULT_SERVER_DATETIME_FORMAT)  - timedelta(weeks=5)
            self.test2 = str(raw)
Avatar
Descartar
Sam F
Autor

which parts of this will i need to change for my custom fields?

DHA Medic

You should share the code you are currently editing.

Thanks

Sam F
Autor

i have, its in the original post.

im using the compute field in the studio.

DHA Medic

from datetime import datetime, timedelta

from odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT

for record in self:

record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)

DHA Medic

Try it bro, i don't test it

[tab]record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)

DHA Medic

My code: pastebin.com/yYTL4E5h

Sam F
Autor

getting the error:

File "/odoo/odoo-server/odoo/tools/safe_eval.py", line 189, in assert_valid_codeobj

raise ValueError("forbidden opcode(s) in %r: %s" % (expr, ', '.join(opname[x] for x in codes)))

ValueError: forbidden opcode(s) in 'from datetime import datetime, timedelta\r\nfrom odoo.tools.misc import DEFAULT_SERVER_DATETIME_FORMAT\r\nfor record in self:\r\n record[("x_studio_field_CgBpj")] = datetime.strptime(record.x_studio_field_47ZJc, DEFAULT_SERVER_DATETIME_FORMAT) - timedelta(weeks=5)': IMPORT_NAME, IMPORT_FROM

Gerardo Busch

Are both fields of the same type? (Datetime or Date). If not, you need to convert it. I tried something similar and this was the problem I had.

Publicaciones relacionadas Respuestas Vistas Actividad
How to get a person's age from his date of birth in Odoo? Resuelto
python compute
Avatar
Avatar
Avatar
2
may 20
6895
How can I do in compute method to differ two datetime ? Resuelto
python compute odoo
Avatar
Avatar
1
ene 17
5921
How do I configure Sales Tax so that it is based on product cost, not the selling price? Resuelto
python tax custom formula
Avatar
Avatar
1
feb 25
1282
compute field not working properly
python model compute technical
Avatar
Avatar
Avatar
2
jun 23
5298
How can I add custom fields that calculate a combination of other fields? Like Sales Margin as a percentage? Without a module. Resuelto
python fields custom v9
Avatar
Avatar
2
abr 23
24458