I have a data table with approximately 10 columns. The rows load in a paginated / lazy loading manner, hence, around 15 records are loaded at a time until you paginate or scroll down. Now, I would want to apply column filters on this table using a list of multi select options. Should this list of options in the filter multi-select list contain only values that have already been loaded in the UI or all possible values that the field could have?
For example (using the screenshot as reference), I want to apply filter on the "Team" column. The UI has only loaded data for Team 1 and Team 2, however, there are more values that haven't been loaded yet (Team 3, Team 4, Team 5 etc). So the question is :