PDA

View Full Version : paged grouped results without splitting group?



smokeman
8 Sep 2010, 12:55 PM
I need to know if it is possible to page a group grid, without splitting a group's results. Right now, I have a grouping grid, with a paging toolbar. I'd like to adjust the pagesize, depending on the grouped results showing.
Has anyone worked out a way to do that?

Mark Wells
17 Sep 2010, 9:09 AM
I solved a similar issue using two SELECT statements in the corresponding php. First I used with LIMIT (using MySQL) clause according with pageSize config (passed as parameter of course).

The second was insert in a for statement that runs pageSize times using values taken from the first SELECT.

Then I grouped this two arrays in a third that's returned to ExtJS, hence I could group all the records I wanted based on a fixed pageSize that's, in fact, the number of grouped "rows".

Hope it helps
Mark Wells

smokeman
17 Sep 2010, 1:10 PM
I'll have to wrap my head around that, thanks!
I don't guess you could show your code for your solution? It might help me understand better(just the php),
I assume that then goes back to a grouping store on the ext side.

thanks again!