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)]

Gerelateerde posts	Antwoorden	Weergaven
Update or modify object field value using self.pool in python Opgelost python sql	1 apr. 15	21980
new python env python	0 mrt. 25	387
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 apr. 24	1217
What means "Too many values to unpack" message? Opgelost python	4 apr. 24	172617
have no data in screen. read data in my own module from different model python	0 dec. 23	1369

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!