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

Related Posts	Replies	Views
Update or modify object field value using self.pool in python Solved python sql	1 Apr 15	21403
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	624
What means "Too many values to unpack" message? Solved python	4 Apr 24	170719
have no data in screen. read data in my own module from different model python	0 Dec 23	601
How to insert value to a one2many field in table with create method? Solved python	5 Nov 24	217110

This question has been flagged

Enjoying the discussion? Don't just read, join in!