Quantity 0 filter for lots list view isn't working but the same filter for products list view is available.

Question

Why is there a filter for products with available quantity but not for lots. If I try to define a filter for lots based on product_qty, it throws error stating that unsearchable field. As per my knowledge, It is because the field is computed field. But the same applies for available_qty in product right ? How's the filter for products on available_qty working?

Niyas Raphy (Walnut Software Solutions) · Answer

Hi,
Even though the qty_available is not a stored field and it is working fine because, if you check the original field definition you can see a search function defined for the field.
qty_available = fields.Float(
'Quantity On Hand', compute='_compute_quantities', *search='_search_qty_available',*
compute_sudo=False, digits='Product Unit of Measure')

By defining search function, we can make non stored fields to be used in search/filter.
See more in:  Searchable Non Stored Compute Field In Odoo

Bài viết liên quan	Trả lời	Lượt xem
How can I filter a field in product.supplierinfo in the product.template model ? Đã xử lý filter domain product supplier odoo10	1 thg 5 18	6624
How to Filter Many2one field from another database table? filter domain product many2one odoo10.0	0 thg 8 17	4655
Make a filter invisible filter v15	2 thg 3 24	1134
I can't create products after massive import Đã xử lý product v15	2 thg 8 22	2231
Filter many2one field with functional field filter domain	5 thg 9 20	12433

Câu hỏi này đã bị gắn cờ

Bạn có hứng thú với cuộc thảo luận không? Đừng chỉ đọc, hãy tham gia nhé!