I have implemented On Demand paging and it's working until you select a column to filter. When a filter is selected, The column filtering modal appears and the distinct values that you can filter by is disabled and hidden and a spinner is displayed. I believe that there is a process to go to to the data source and select the distinct values for that column for the complete data set, but I can't find any API or examples of the correct flow to accomplish this.
Can you provide a FULL example of On Demand with Filtering so that I can see the workflow that should be followed? What method(s) need to be used to populate the filter modal and allow the user to select a filter value and proceed out of the filtering modal?