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

관련 게시물	답글	화면
Update or modify object field value using self.pool in python 해결 완료 python sql	1 4월 15	23545
new python env python	0 3월 25	2348
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 4월 24	2516
What means "Too many values to unpack" message? 해결 완료 python	4 4월 24	175842
have no data in screen. read data in my own module from different model python	0 12월 23	2959

신고된 질문입니다

토론이 재미있으신가요? 직접 참여해보세요!