I am trying to create a filtering page that takes the unique values from each of the columns of the grid/datatable and make them a clickable hyperlink to programmatically do the filtering for the grid/datatable. Doing this wasn’t difficult, the problem comes once they’ve clicked a column’s value and the filter is applied, I need the list of columns/unique values to then reduce to what is available left in the grid.
First Name grid or datatable
Bob, Eric, Jenny, John
Ericcson, Brown, Smith
I click the firstName of ‘Bob’, the grid applies the filter and only Bob’s records. The Filters should then reconfigure to show only those unique values left in the grid. Ex: There are 10 records with Bob, but 3 different last names, so those would show until the user clicks to filter it further. I’m trying to do this all client-side, but can’t figure it out to reuse the grid’s dataAdapter to re-filter the data for my text/hyperlink filters.