OpenERP 6.1/ How do I link records contained in the same table?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

إدارة علاقات العملاء
e-Commerce
المحاسبة
المخزون
PoS
Project
MRP

All apps

كافة المنشورات الأفراد الشارات

علامات التصنيف (عرض الكل)

odoo accounting v14 pos v15

حول هذا المنتدى

المساعدة

OpenERP 6.1/ How do I link records contained in the same table?

link record

2 الردود

4369 أدوات العرض

Stjepan Lovasić

Hello,

I have the following problem:

I have started work on an OpenERP module used for quality control, and one requirement for it to work is having linked quality parameters. Each parameter record has a field called 'formula' where I should be able to calculate the value for the parameter based on a dependent parameter.

For example, if I have a 'weight' parameter and a 'tolerance' parameter, I would like to have a 'foreign substance' parameter, where I would calculate the values for the 'foreign substance' parameter through the formula field, for instance 'weight'/'tolerance'.

The formula field would contain text that would be executed as Python code.

My question is, how would I indicate to the 'foreign substance' parameter that it should take into account the values of the other two when calculating its values?

Best regards, Stjepan

Brett Lehrer

أفضل إجابة

Use a function field, and have it pull the values of those other fields as well as the formula text? You'd have to be able to parse the formula text to replace the variables with the object references. Or, state that the syntax is

obj.weight/obj.tolerance

Once you're in the function calculating the 'foreign substance' field, make sure the object name is obj:

from openerp.tools import safe_eval
objs = self.pool.get('quality.control').browse(cr, uid, ids)
for obj in objs:
    foreign_substance = safe_eval(obj.formula)

There are more functions in safe_eval.py that you probably want to look into, just to make sure that nobody breaks your system with a bad formula.

Stjepan Lovasić

الكاتب

Thanks, I think this is just what I was looking for. Solved

Gustavo

Take a look at the bill of material model, it implements the recursivity you are talking about

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

أنشئ حساباً اليوم لتستمتع بالخصائص الحصرية، وتفاعل مع مجتمعنا الرائع!

تسجيل

المنشورات ذات الصلة	الردود	أدوات العرض
Can I create new menu in the sales module and give alink to the odoo spreadsheet in V17 ent ? link	0 أكتوبر 24	1378
Liens de texte dans une même page link	1 نوفمبر 23	2643
In Report module when we create own Footer giving error record	2 يونيو 16	3366
(Odoo 8) Access rights to project.task record	3 يناير 16	4661
Open a web link in a new tab from the chatbot تم الحل link chatbot	2 أكتوبر 24	1472

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

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