I have an advancedDataGrid that I need to add custom sorting to it which overrides the original sort! my sorting should work using a combobox to select ascending and desending from with a sort button! I know this is a bug in flex that its original sorting only works in hierarchical data and not for groupingCollection
the dataProvider of my grid is a flat data. however, in the UI, the user can add grouping to the AdvancedDataGrid. so I want the sort to work on grouped data!
let's say the columns are : country, province, city. population and there is grouping on country and province
so the sorting should do the following:
1) if the user does a descending sort on country: only unitedStates will go up and Canada will go down.
2)if the user does a descending sort on province: the order of the grouping of province will change to Quebec, Ontario, British Columbia
3) if the user does a soring on city: although this is not a grouped column, it should do the sorting on all the cities.