How to set or update fields.function value of existing data ?

Question

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,

Henri-Maxime Ducoulombier · Accepted Answer

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.

Antonio Antiun · Answer

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*

Ray Carnes · Answer

Export the model records, then import them.

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

المنشورات ذات الصلة	الردود	أدوات العرض
How to declare views in openerp 7.0? views fields 7.0	3 مارس 15	6797
How to display a red * for required fields fields	3 مايو 25	3363
How to display a red * for required fields fields	1 أبريل 25	2403
one2one relational field تم الحل fields	3 سبتمبر 24	16060
I cannot see custom field in lead form fields	2 فبراير 24	3453

لقد تم الإبلاغ عن هذا السؤال

هل أعجبك النقاش؟ لا تكن مستمعاً فقط. شاركنا!