Forum
17:51
19/04/2009
I'm trying out jqgrid plugin and it seems to fit most of my need, that's a nice plugin.
Only thing that is missing out for a project I work on, is line grouping or nesting, I need to allow two level of grouping over the same set of data (that is not hierarchical data).
What I mean is something like outlook "group by", let say we have buyorder list, here is some sample of what an user would like:
- group them by date and status and sort by customer
- group them by status and customer, and sort by date
- ... you get the idea
How this will fit? here is a naïve idea:
the server will return data ordered by the grouped column(s) then the column order (this mean multiple order clauses)
the client will iterate over each row comparing the cells value with previous row corresponding to the grouping parameters:
if the values are identical, render the row as expected, if the value are not the same, then a grouping row need to be rendered.
The grouping rows could be collapsed/expanded at will.
Is there already a way to achieve this? if not is this something that would fit with jqGrid API?
07:22
Moderators
30/10/2007
Hello,
You can use a grid as subgrid for this purpose (If I understand right) . See examples
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
09:04
19/04/2009
Hello Tony, thanks for your answer.
The subgrid (and sub-subgrid for the matter because I need at least 2 nesting levels) wouldn't fit because
- Groups are solely label (no need for X columns), not a master-detail scenario
- I need the column of the main table to match the nested data (buyorder attributes in my example).
- I don't want the columns header of nested data to be repeated for every nested group
Line breaks are just rows with a single column (and according colspan),
see http://extjs.com/deploy/dev/ex.....uping.html as an example
A solution could be a handle function called before each row which would be allowed to inject arbitrary row would allow such customization (compare current row with previous and determine if a group break is needed or not), the last remaining part would be the collapsing/expanding feature of theses grouped rows.
Would this be doable without impacting the actual code base?
or is it a feature that match other people needs?
07:46
Moderators
30/10/2007
Hello,
Looking into the extjs I see what you mean. Currently this is not supported, but definitley I will add it in the todo list.
Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
07:53
Hello Tony!
Is there any way to implement this feature nearest time? At the moment we are in the middle of investigation in order to choose datagrid for our new project, and we was going to choose jqGrid... But one of the main requirements in our project is ability to group rows by columns.
Unfortunately if this feature will not be implemented - we will have to choose another solution 🙁
But I really like jqGrid and hope to find the solution...
P.S. Another online demo's from different products (maybe to better understand the idea and usefullness of the feature):
- http://dhtmlx.com/docs/product.....group.html
- http://demos.telerik.com/aspne.....ultcs.aspx
- http://www.treegrid.com/treegrid/www/
With respect,
Andrew TheBit Halyasovskyy
05:39
Moderators
30/10/2007
Hello Andrew,
Thanks for the recommendation.
Yes, I know about these. Simple - yes - there are plans to implement this feature.
Currently I'm working on 3.6 relese, where this feature is not included.
It will be in 3.7. The first beta of 3.6 is expected after a week.
Best Regards
Tony
For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.
03:33
01/10/2009
gauthier, TheBit, have you seen this one yet: http://p.sohei.org/jquery-plug.....ablegroup/
It's jQuery-based. Perhaps it can be adapted as a jqGrid plugin.
Most Users Ever Online: 715
Currently Online:
57 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66