Hello,
I'm using the DataGrid control with the built-in filter row and excel-like filter pop-up. The default behaviour here is that filtering is done in-memory. That's great in most cases but I'm now facing a scenario with a list of 200k items which is why I'm using the IncrementalList pattern.
Because I'm now loading my data from my database as the user scrolls, the in-memory filtering no longer meets the requirements as it now only searches the already loaded data. I would like to map the SF FilterPredicates to my database while maintaining the built-in filter row and popup. However I'm struggling to find the correct way to overwrite this default in-memory filtering behaviour. What's the recommended way of achieving this behaviour?
Kind regards,
Floris