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

Related Posts	Ответы	Просмотры
How can I filter a field in product.supplierinfo in the product.template model ? Решено filter domain product supplier odoo10	1 мая 18	7053
How to Filter Many2one field from another database table? filter domain product many2one odoo10.0	0 авг. 17	5099
Make a filter invisible filter v15	2 мар. 24	1970
I can't create products after massive import Решено product v15	2 авг. 22	2861
Filter many2one field with functional field filter domain	5 сент. 20	13143

Этот вопрос был отмечен

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