Skip to Content
This question has been flagged
browseORMv15
2 Replies
2734 Rodiniai
Portretas
Rachid

I have a custom model with an init view for _auto = False when I access the list view I got wrong data in a Many2one field analytic_line_type_id ! Debugging results:

 > /odoo/odoo-server/odoo/models.py(3247)_read_format()
-> for record, vals in data:
(Pdb) record[name], record.analytic_line_type_id,  self.env[self._name].search_read([('id','=',record.id)],['analytic_line_type_id'])[0]
(account.analytic.line.type(1,), account.analytic.line.type(1,), {'id': 9057, 'analytic_line_type_id': (15, "Temps d'assemblage atelier")})
(Pdb) record[name], record.analytic_line_type_id,  self.env[self._name].search_read([('id','=',record.id)],['analytic_line_type_id'])[0]
(account.analytic.line.type(15,), account.analytic.line.type(15,), {'id': 9057, 'analytic_line_type_id': (15, "Temps d'assemblage atelier")})
(Pdb) record[name], record.analytic_line_type_id,  self.env[self._name].search_read([('id','=',record.id)],['analytic_line_type_id'])[0]
(account.analytic.line.type(15,), account.analytic.line.type(15,), {'id': 9057, 'analytic_line_type_id': (15, "Temps d'assemblage atelier")})

Why record.analytic_line_type is not correct in the first call ?
As you can see the search_read value is different to direct access to the field!

Portretas
Atmesti
Portretas
Rachid
Autorius Best Answer

in the sql view the id may changes, I added the field on the order by of the row_number()

row_number() OVER ( order by analytic_line_type_id)
Portretas
Atmesti
Portretas
Niyas Raphy (Walnut Software Solutions)
Best Answer

HI,
Here you cannot trust the id of the record as it is a dynamic one and keeps changing when the model/view is loaded. Try using search_read orm method or give a id value to the records which cannot be changed.



Thanks

Portretas
Atmesti
Rachid
Autorius

Hello Niyas,
thank you for reminding me about that.
I access the values from the list view, the data in the list is not correct, but if I group by that field I got the right value returned by search_read!
everything works fine till now, when the view had more data I got this behaviors.
after looking deeply in the sql view I added the field analytic_line_type_id on the row_number() OVER ( order by analytic_line_type_id)

Related Posts Replies Rodiniai Veikla
why ORM methods not working properly in custom module
search browse ORM v15
Portretas
Portretas
1
kov. 22
3774
Prevent navigation if records are not save
v15
Portretas
Portretas
Portretas
2
spal. 25
3307
Creating user creates duplicated partner_id
v15
Portretas
Portretas
1
rugs. 25
3215
Sales order line comment to Purchase order line comment Solved
v15
Portretas
Portretas
3
liep. 25
4466
attribute is not applied when dynamically rendering
v15
Portretas
1
geg. 25
2601