Community mailing list archives

community@mail.odoo.com

Re: Odoo 8 computed field issue

by
Skillteam, Houssine BAKKALI
- 11/20/2015 05:15:41
if the three fields of your domain are stored in the db. try your domain in postgress using filter on the table. You will be fixed of the correctness of your domain

2015-11-20 10:42 GMT+01:00 Yassine Teimi <yteimi01@gmail.com>:
Dears, 

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 

class SurveyUserInputLine(models.Model):
    _inherit = 'survey.user_input_line'
     percentage_row = fields.Float('Atteinte objectif', compute='_compute_percentage_row', store=True)
   
     @api.multi
    @api.depends('value_number','user_input_id','value_suggested_row','col_label')
    
    def _compute_percentage_row(self):
        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 ... 



--

Cordialement

Yassine TEIMI

Consultant & Odoo Project Manager
TEL : +212 6-27 33 30 78

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe