I want to take the JQuery kendo grid I have and its 3 filters, and make them cascading filters. I have Year, Make, Model filters, when a user filters the dataSource on Year, I want the only options in Make to be the available Make's after the Year filter is applied to the dataSource. Have this functionality work in any order. I have accomplished this by applying the same dataSource from the grid to each of the 3 columns filter.dataSource. However, this shows every year, every make, and every model that is available in the filter dropdown. see http://dojo.telerik.com/AyEca/2. The reason this is working to my understanding is that I am manipulating the dataSource when I apply a filter which is updating the column filter dataSource as well, giving me only filter options that exist in the current filtered dataSource of the grid.
However, my dataSource is 4,000 large, with multiple years, makes, and models. So the user would see somewhere around 500 2004 before they would see a 2005 filter option. This obviously for usability does not work as a final solution. What I have done is found this query which allows me to get the filtered dataSource.
What I want to do is grab the years, makes, and models out of each of those and create a array of data that is unique and sorted and apply that to their respected column filter datasource. Is this possible, how would I accomplish this? Also is there a another simpler way to create cascading filters that only have unique and sorted filter options. Here is my current code.