I am using odoo14, and trying to search attachments with store_fname or checksum.

But I found that even I copy a store_fname or a checksum from database to fill in the search command like:

self.env['ir.attachment'].search([('store_fname', '=', 'store_fname')])

It always returns None. but if I search with id field, it returns the currect record, but I just want to get all attachment records with the same store_fname. So it's vital to get all records in order to go next step.

And I found that the count of orm result does not match the count of records that in the database.

I searched with empty condition, then I got only 500+ results.

But there are actually over 90k records in the database.

How's that happen?

I do not have any clue with it.

Waiting for your help & Regards.