Forum

November 2nd, 2014
A A A
Avatar

Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

The forums are currently locked and only available for read only access
sp_Feed Topic RSS sp_TopicIcon
line grouping / nesting / breaking
18/04/2009
17:51
Avatar
gauthier
New Member
Members
Forum Posts: 2
Member Since:
19/04/2009
sp_UserOfflineSmall Offline

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?

20/04/2009
07:22
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

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.

20/04/2009
09:04
Avatar
gauthier
New Member
Members
Forum Posts: 2
Member Since:
19/04/2009
sp_UserOfflineSmall Offline

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?

22/04/2009
07:46
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

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.

05/10/2009
07:53
Avatar
TheBit
Guest
Guests

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

06/10/2009
05:39
Avatar
tony
Sofia, Bulgaria
Moderator
Members

Moderators
Forum Posts: 7721
Member Since:
30/10/2007
sp_UserOfflineSmall Offline

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.

20/10/2009
20:06
Avatar
michael
Member
Members
Forum Posts: 12
Member Since:
01/10/2009
sp_UserOfflineSmall Offline

Hi, sorry to drop in but I'd just like to say this is also the kind of feature I need from jqGrid. It would be great! Thanks for your efforts Tony.

23/10/2009
03:33
Avatar
michael
Member
Members
Forum Posts: 12
Member Since:
01/10/2009
sp_UserOfflineSmall Offline

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.

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
44 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.com

Moderators: tony: 7721, Rumen[Trirand]: 81

Administrators: admin: 66

Comments are closed.
Privacy Policy   Terms and Conditions   Contact Information