I am programatically updating the qty column values for configurable products.
Sadly, the grid filter for this column doesn't work with new values.
The underlying catalog product collection joins with cataloginventory_stock_item table for this field, via the Magento\CatalogInventory\Ui\DataProvider\Product\AddQuantityFieldToCollection DataProvider field strategy, and since I haven't changed the qty column values inside the database I don't see the correct results.
The filter works if value 0 (which is the default conf products qty value stored in db) is used in filter.
Can I filter the collection for this field based on the programatically calculated values I am displaying in the grid and how exactly?
Is it possible and how can I join on programatic values instead of a db table column?
Thnx.