Odoo is the world's easiest all-in-one management software. It includes hundreds of business apps:
CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
I want to create a computed field, wich multiplies two different field values :
The first field value is on the current record.
The second field value is on another record (on the same model), and then should be searched, and retrieved, following some conditions.
(I'm trying to get two values for the same field, but on two different records, of course because the field value changes from a record to another)
Here is my code :
from openerp import models, fields, api
_inherit = 'survey.user_input_line'
percentage_row = fields.Float('Atteinte objectif', compute='_compute_percentage_row', store=True)
for record in self:
if record.col_label == 'Pondera':
pond = record.value_number
id_token = record.user_input_id.token
row_value = record.value_suggested_row.id
domain = [('col_label','=','Resultat'),('value_suggested_row.id','=', row_value),('user_input _id.token','=', id_token)]
result = self.search(domain).value_number
record.percentage_row = float(result*pond)/100
My problem is on the line in bold, it doesn't retrieve anything, the domain seems correct.
Maybe there is another way to achieve my query.
For further informations, it's on the survey_user_input_line object, and I'm trying to do the multiplication of two values but not on the same record.
Thanks for your help, I'm blocked ...
About This Community
This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.Register
Odoo Training Center
Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.Test it now
|Asked: 11/20/15, 4:41 AM|
|Seen: 901 times|
|Last updated: 11/20/15, 4:41 AM|