I have a grid using FilterMode="FilterMode.CheckBoxList"
I've converted it to use server side paging and filtering because my dataset is large and the grid is complex with a lot of columns and thus slow.
Is there a way to set the available options for filter list?
right now it only gives the options for what is on the current page, not all the available options. I understand why, but I want to override that and provide a fixed list for one of my columns.
say the database contains rows with the number column for 1,2,3 but the first page only has rows with 1 and 2 in them, only 1 and 2 will show in the filter and then there is no way to filter by 3 which I need to do.