I have a ext.GroupingView grid that paginates, filters, and obviously groups.
The combination of these options is both awesome and beyond the scope of this discussion.
The problem is, the params request when a user wants a new set of results is something that bears no resemblance to the database schema.
I've ended up doing something like this: http://pastebin.com/m7d998444
That looks like hell, I'm not sure it works, and I dread the idea of maintaining it.
Is there a better solution out there? For those not wanting to look at the horrors beyond that link, I need something to take a filter string with a value, an offset, a group key, a limit, a sort key with ASC>DESC, and turn it into a query that spits out an array of objects sorted first by group and then again by sort.
Thanks in advance -
Alex