Multiple level of grouping in grids

[venky0589]

I think that You should make things easier to make more agile all of help process.

I have not any server instaled for test. Is posible a Local example?

Thanks in advance,

Replace the file Multi.js in the previous zip folder for example to work locally

[galdaka]

Hi,

Thanks venky0589!!!

Is a excellent start for make Treegrid

[bvutukur]

hi galdaka,

the multigrouping is working fine for the example given by you.

i created multi_new.js to add my own column's. but when i am trying to drag any one of the column i am getting a script error saying 'this.fields' is null or not an object.

can you help me to resolve this issue. i am attaching the multi_new.js that i am using.

how to make the columns editable?

Thanks in Advance

[ut_paule]

I spent a day looking for this, and what you posted in #14 seems to be the best thing i could find (Unless Animal released his version somewhere).

I have just spent a day hacking this around to do the following things

1. work on IE (i use v6)
2. to use the column headers, not the dataIndex names in the Group Text and on the toolbar (This was tricky as the dataIndex name was used internally in many places)
3. to make sure all groups had "rs" set (not just the final group) so i could see at the higher levels total record counts
4. I tried to indent the row so it was nested under groups, so it all still looks indented, this kind of works on FF, but not on IE (i am adding a margin-left on the x-grid3-row and header). I think this also screws up the basic sizing in ExtJS, like auto width etc, so i probably need a better way to do this
5. It seemed like getRows() is called many times and is an expensive routine, so i added in a cache for this - i welcome feedback as to whether this is a good idea
6. I also created a MultiGroupingPanel, to try and hide all the dropdown/toolbar stuff, i did notice in the process that there are some hardcoded things that probably need to be addressed to make this a true panel, where you can have more that one on the page (for example lines like clone.id = Ext.id('ven'); concern me.

You will see in the attached example huge amounts of firebug debugging, and i will continue to work on this some more, and try and gauge any feed back from others trying to sort this out.

One issue i have, as this is my first exposure to the DD stuff, is that when you drag a column to the toolbar, and in the process the "blue arrows" for moving the column appear they still stay there after the drag event has finished.

My intent is to have a final working version within an week or so, it will be under an LGPL and be part of the JaffaRIA module under the jaffa.sf.net (That is where my team are sticking all our ExtJS extensions and DWR intergration)

Future things i want to do to it are

1. make sure it works with the filter plug-in (how can you filter on a grouped column if it has been hidden) should there be a dropdown against the column name in the toolbar too?)
2. get it working with some kind of paging store
3. integrate the store with DWR (as that is what my project uses to access the DB)
4. support some kind of Export to Excel...
5. get the groupTpl so that can do totaling of other columns, beyond the simple rs.length counting
6. like Animals demo drag and drop to re-order groups would be nice
7. full state management intergration so it remembers what you were grouping by last time

[galdaka]

ut_paule live example here:

http://www.jadacosta.es/extjs/exampl...ultiGroup.html

Thanks ut_paule. Great work!!!!

P.D: Awesome screenshot in FF2!!!!!!

[venky0589]

I spent a day looking for this, and what you posted in #14 seems to be the best thing i could find (Unless Animal released his version somewhere).

I have just spent a day hacking this around to do the following things

1. work on IE (i use v6)
2. to use the column headers, not the dataIndex names in the Group Text and on the toolbar (This was tricky as the dataIndex name was used internally in many places)
3. to make sure all groups had "rs" set (not just the final group) so i could see at the higher levels total record counts
4. I tried to indent the row so it was nested under groups, so it all still looks indented, this kind of works on FF, but not on IE (i am adding a margin-left on the x-grid3-row and header). I think this also screws up the basic sizing in ExtJS, like auto width etc, so i probably need a better way to do this
5. It seemed like getRows() is called many times and is an expensive routine, so i added in a cache for this - i welcome feedback as to whether this is a good idea
6. I also created a MultiGroupingPanel, to try and hide all the dropdown/toolbar stuff, i did notice in the process that there are some hardcoded things that probably need to be addressed to make this a true panel, where you can have more that one on the page (for example lines like clone.id = Ext.id('ven'); concern me.

You will see in the attached example huge amounts of firebug debugging, and i will continue to work on this some more, and try and gauge any feed back from others trying to sort this out.

One issue i have, as this is my first exposure to the DD stuff, is that when you drag a column to the toolbar, and in the process the "blue arrows" for moving the column appear they still stay there after the drag event has finished.

My intent is to have a final working version within an week or so, it will be under an LGPL and be part of the JaffaRIA module under the jaffa.sf.net (That is where my team are sticking all our ExtJS extensions and DWR intergration)

Future things i want to do to it are

1. make sure it works with the filter plug-in (how can you filter on a grouped column if it has been hidden) should there be a dropdown against the column name in the toolbar too?)
2. get it working with some kind of paging store
3. integrate the store with DWR (as that is what my project uses to access the D
4. support some kind of Export to Excel...
5. get the groupTpl so that can do totaling of other columns, beyond the simple rs.length counting
6. like Animals demo drag and drop to re-order groups would be nice
7. full state management intergration so it remembers what you were grouping by last time

clone.id = Ext.id('ven');
clone.id = Ext.id(); This will not show error in FF but in ie it will show as object expected .

thanks for updates,

[st_gross]

ut_paule live example here:

http://www.jadacosta.es/extjs/exampl...ultiGroup.html

Thanks ut_paule. Great work!!!!

P.D: Awesome screenshot in FF2!!!!!!

Indeed this looks great and is very promising!

A remaining problem seems to be column reordering after grouping.
Try to shift the Serial column left in the live example. You'll see the group title Part will
change to Serial after that. But this should be a minor issue (I hope)

Cheers
Stefan

[DamienValentine]

Hi all. I found that code completelly independent and very useful. I got it to work in my application even when I have to create grids in a windows builded by xml templates. But I am a little bit confused with grouping by date. I can't get it to work and in provided example there is the same problem - each date is a group even when dates are the same. How to fight that?
p.s. sorry for my english . i am ukrainian.
===added
In previous examples everything works fine...
Firebug gives "Row 18 added group. Values differ: prev= Wed Aug 06 2008 00:00:00 GMT+0300 curr= Wed Aug 06 2008 00:00:00 GMT+0300" but previous and current values are the same I guess . I was thinking about checking field type and then format date to string but this is nonsense, besides in early posts this works fine.

[galdaka]

Hi all. I found that code completelly independent and very useful. I got it to work in my application even when I have to create grids in a windows builded by xml templates. But I am a little bit confused with grouping by date. I can't get it to work and in provided example there is the same problem - each date is a group even when dates are the same. How to fight that?
p.s. sorry for my english . i am ukrainian.
===added
In previous examples everything works fine...
Firebug gives "Row 18 added group. Values differ: prev= Wed Aug 06 2008 00:00:00 GMT+0300 curr= Wed Aug 06 2008 00:00:00 GMT+0300" but previous and current values are the same I guess . I was thinking about checking field type and then format date to string but this is nonsense, besides in early posts this works fine.

http://www.jadacosta.es/extjs/exampl...ultiGroup.html

[DamienValentine]

Please, ungroup everything and group by ECD field then. If it works right for you and do not creates 6 groupes with the same name - please, give me know.