self.env.search_count returns different result from self._cr.execute

Question

I tried to get the records count from ir.attachment using two methods:

1. Executed SQL code with self._cr.execute:
query="""select count(*) from ir_attachment"""
cr=self._cr
cr.execute(query)
val=cr.dictfetchall()
for r in val:
print ("SQL returns....",r)

Code returned 364 rows

2. Using the self.env.search_count:
val=self.env['ir.attachment'].sudo().search_count([])
print ("search_count returns....",val)

In this case the result is 259 rows

Why the difference in the results? Why search_count

faOtools · Accepted Answer

Hi!
The model ir.attachment is quite specific in Odoo. In particular, it redefines the _search method and excludes by default attachments related to fields (with res_field set). Thus, the results might differ even under sudo(). If it is important for you, you should get deep in  https://github.com/odoo/odoo/blob/15.0/odoo/addons/base/models/ir_attachment.py [1]
Generally, the _search, search, search_count method might give different results than a direct SQL query, since they are redefined per a

Panos Anagnostakis · Answer

Thanks for the answer!
It helped me to solve the problem by searching for true and false res_id fields, using the following domain:
['|', ('res_field', '!=', False), ('res_field', '=',False)]

Powiązane posty	Odpowiedzi	Widoki
Update or modify object field value using self.pool in python Rozwiązane python sql	1 kwi 15	23495
new python env python	0 mar 25	2317
Hello, I would like to know how I could execute this query only for one record and not have it executed on the entire table. python query records sql	1 kwi 24	2482
What means "Too many values to unpack" message? Rozwiązane python	4 kwi 24	175772
have no data in screen. read data in my own module from different model python	0 gru 23	2936

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!