Skip to Content
Menu
This question has been flagged
1 Atsakyti
10273 Rodiniai

Hello everyone,

I try to calculate the value depending on previous record this is my code

 @api.depends('odometer')
    def get_km_parcouru(self):
        for record in self.sorted(lambda x: x.id):
            prev = self.env['fleet.vehicle.log.fuel'].search_read(
                [('id', '<', record.id)], order='date desc', limit=1)
            prev_record = prev[0]['odometer'] if prev else 0
            record.km_parcouru = record.odometer - prev_record

When I click on crate button I get this error 

ProgrammingError: can't adapt type 'NewId'

In:

 [('id', '<', record.id)], order='date desc', limit=1) 

Portretas
Atmesti
Best Answer

At create moment the value record.id not exist in datatbase. When creating a record a model with computed fields, the records of the recordset will be in memory only. At that time the id of the record will be a dummy ids of type openerp.models.NewId

Portretas
Atmesti
Related Posts Replies Rodiniai Veikla
2
liep. 24
15679
2
rugs. 23
8514
1
bal. 20
4815
5
rugs. 19
5224
0
rugs. 19
2660