Hey all...
I'm trying to figure out something that's either probably pathetically simple and is for some reason just eluding me or it's not possible and I've pulled all this hair out for nothing...
I know that when you just add the .Filterable property onto a column it adds the nifty little filter onto it that's pretty awesome out of box. The one small over-site IMHO is that it is not a distinct list and is not sorted. I haven't seen any options to enable these sort of things...and I've been reading posts from others looking for this sort of functionality...and they've been told it's not there yet.
So what I want to do is to pass the Grid's DataSource into a controller action as an argument using the .Data off the .Read in the .Filterable's .DataSource...then inside that controller action I'd use a Linq query to return a sorted distinct list.
The reason I want to do that is I want to avoid having to make another call across the wire to get all those record when I already had them in the grid...it should be more performant IMHO. :)
So is this possible and I'm just missing it? I'm using Razor so I'd appreciate any examples to be in that format, but I'll take any help in any format I can get. :)