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	22631
new python env python	0 3月 25	1347
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	1774
What means "Too many values to unpack" message? 已解決 python	4 4月 24	174210
have no data in screen. read data in my own module from different model python	0 12月 23	2128

此問題已被標幟

喜歡這則討論？不要只閱讀，加入發表意見吧！