Skip to Content
Menu
This question has been flagged
1 Reply
8701 Views

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) 

Avatar
Discard
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

Avatar
Discard
Related Posts Replies Views Activity
2
Jul 24
13934
2
Sep 23
6682
1
Apr 20
3599
5
Sep 19
4158
0
Sep 19
1837