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

Question

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 *

Brett Lehrer · Accepted Answer

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 = sa

Gustavo · Answer

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

Bài viết liên quan	Trả lời	Lượt xem
Can I create new menu in the sales module and give alink to the odoo spreadsheet in V17 ent ? link	0 thg 10 24	1390
Liens de texte dans une même page link	1 thg 11 23	2653
In Report module when we create own Footer giving error record	2 thg 6 16	3379
(Odoo 8) Access rights to project.task record	3 thg 1 16	4680
Open a web link in a new tab from the chatbot Đã xử lý link chatbot	2 thg 10 24	1489

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!