Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
6 Odpovědi
30715 Zobrazení

Hello,

I just add a fields.function(_myfunc, .... , store=True) on one OpenERP V7 model. This instance allready has some value in database.

How can I force openERP to compute the value for this field ? New data are ok (set when write method is launch) but for existing one nothing ...!

Note:

If a change store=True with store=False, my data are ok, but I need to add this field on search filters.

thanks for your help,

Avatar
Zrušit
Nejlepší odpověď

I recently came across this kind of problem (needed to update computed values) and I created a module to add 2 methods to the ORM (compute and compute_all).

You can find it here if you want, and if you ever get a chance to test if on Odoo 8+, let me know (I'm using OpenERP 7.0)

https://github.com/H-Max/odoo-orm-recompute

Hope this helps.

Avatar
Zrušit

Thanks Henri! It works for v8 in my case!

Nejlepší odpověď

You could remove the column from database, for example, for field 'margin' at sale.order model you could execute next SQL with psql:

your_database=> alter table sale_order drop column if exists margin;

Then update the addon in Configuration > Local modules

If you look at Odoo log file you will see one line like:

openerp.models: Storing computed values of sale.order fields margin

Avatar
Zrušit
Nejlepší odpověď

Export the model records, then import them.

This will trigger the write and the values for the functional field will be computed and stored.

Avatar
Zrušit
Autor

If I trigger a write method all my value will be updated ?

Hy, is this the only way to do this? Isn't it possible to generate a write trigger during installation process?

The best answer I found is here : http://forum.openerp.com/forum/topic30196.html

Related Posts Odpovědi Zobrazení Aktivita
3
bře 15
5998
3
kvě 25
1817
1
dub 25
1350
3
zář 24
14265
2
úno 24
2519