Let's say we have a grid displaying orders: Order ID, Customer Name, Product Name. The grid is displaying the "ProductName" but filtering needs to be done by "ProductID". If we have thousands of products, we don't want to populate the combobox with everything, but instead might want to use remote data (filtering/virtualization). Most examples I find assume there is local data in some json file. How can we implement a custom grid filter cell that has a combobox that uses remote data?
My understanding is that the filter row is stateless and controlled by the grid. If I implement a custom combobox with remote data as soon as I filter the grid via the GridFilterCellProps onChange, the filter cell state is lost (so no more loaded data matching the selected item) and appears that nothing is selected even though a filter is applied.
I've tried to store the state outside of the filter cell, but I can't seem to get it right. Anyone else have any luck doing something like this?