jQWidgets Forums

Peter,

In the given example, Price column is used for grouping and same is used for calculating the sum using “getcolumnaggregateddata” method.

In my case, I need to use one column as group header and get another column values which are sub-rows of that group header.

For your better under standing below is my column structure,

var columns = [
{ text: ‘Account‘, filtertype: ‘checkedlist’, datafield: ‘AccountName’, width:”60%”},
{ text: ‘Service‘, datafield: ‘Service’, width:”10%”},
{ text: ‘View’, datafield: ‘View’, cellsalign: ‘center’, align: ‘center’, columntype: ‘checkbox’, filterable: true, filtertype: ‘bool’, width:”10%”, editable: true},
{ text: ‘Edit’, datafield: ‘Edit’, cellsalign: ‘center’, align: ‘center’, columntype: ‘checkbox’, width:”10%”, editable: true,filterable: false},
{ text: ‘Ccy’, datafield: ‘Ccy’, cellsalign: ‘center’, align: ‘center’, width:”10%”, editable: true,filterable: false},
{ text: ‘Limits’, datafield: ‘Limits’, align: ‘center’, cellsalign: ‘center’, editable: false,filterable: true}
];

In my XML, I’ve different accounts which shares the same service, so I’m using “Service” column as group header and I want to retrieve each “Account Name” column values which are sub-rows of that group header. That values, I’ll customize in the header and I’ll show through tooltip when all group headers are in collapsed state.

I hope you are understanding my requirement. Below is the structure for your reference,

Account Name | Ccy | Limits
——————————————————————————–
> Service: Service Name (4) | Icon
——————————————————————————–
Account 1 | EUR | 20,000
Account 2 | EUR | 5,000
Account 3 | EUR | 3,000
Account 4 | EUR | 2,000
——————————————————————————–
> Service: Service Name (2) | Icon
——————————————————————————–
Account 1 | EUR | 20,000
Account 2 | EUR | 5,000

Here, I need to get Account Name column values under each group header. Which I will shown in tooltip when all group headers are in collapsed state.

Looking for your solution.

\_rssb

Hi,

We are about to integrate a jqWidget components(Grid, Splitter etc.) in one of our big project and planning to buy for commercial use. Hence we require this support to get this grid issue fixed to go ahead for purchase. This issue seems to be a show stopper for us to proceed further.

Looking for a solution.

Regards,
\_rssb