sorting based on multiple columns in grid

hello

we have one table which has column by name category_name in that some are parent and some are child categories.here only i have another column called parent_category where the entries describe the parent category(here category_id) of a particular category.

now my task is to sort all the categories which come under a particular parent seperately.(i think this is simlar to orderby and groupby clauses in sql which i want to do dynamically in grid(preferably in java script).

thanks in advance.

sreelatha

Starting with 1.0.1 the grid has 'stable' sorting algorithm, which means if you first sort on your sub-category and then on parent category you should get the desired effect.