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

Verknüpfte Beiträge	Antworten	Ansichten
How can I filter a field in product.supplierinfo in the product.template model ? Gelöst filter domain product supplier odoo10	1 Mai 18	7057
How to Filter Many2one field from another database table? filter domain product many2one odoo10.0	0 Aug. 17	5107
Make a filter invisible filter v15	2 März 24	1975
I can't create products after massive import Gelöst product v15	2 Aug. 22	2869
Filter many2one field with functional field filter domain	5 Sept. 20	13157

Diese Frage wurde gekennzeichnet

Diskutieren Sie gerne? Treten Sie bei, statt nur zu lesen!