Intersoft Community - WebGrid Enterprise - cells value in grouping columns

cells value in grouping columns

handy@intersoftpt.com — Tue, 06 Oct 2009 03:15:39 GMT

No, you could not do that in that way because HiddenDataMember property or hidden fields only available in WebGridColumn level. When you used group mode, the structure of field changed into GroupColumn. GroupColumn does not have that propery. If you still want to access HiddenDataMember, you will need to set HideColumnsWhenGrouped to no. With this properties, when in group mode, the column which is used for grouping will still remain. Hope this helps.

Regards,
Handy

cells value in grouping columns

vangeloni — Tue, 06 Oct 2009 03:04:47 GMT

Hi,

ok, in that mode i can get the cell.Text anyway i need to get also any hidden fields (custom attributes) related to that cell, how to retrieve those?

Thanks,

Vince

cells value in grouping columns

handy@intersoftpt.com — Mon, 05 Oct 2009 22:27:07 GMT

If the city has been used as group column and you wanted to get the information of the city, you can do with my previous code i gave your.

function doButtonClick()
{ 
    //get the grid object
    var grid = ISGetObject("WebGrid1"); 
    //make sure the grid is grouped
    if (grid.RootTable.GroupedColumns.length > 0) 
    { 
        //get the first group row element
        var firstGroupRow = wgGetRowByGroup(grid.RootTable.GetElement(WG40.BODY,WG40.HTMLTABLE),0,0); 
        alert(firstGroupRow.innerText); 
    }
}

(0,0)>> the first index 0>> please fill it with 0 if it only has 1 grouping columns...
>> the second index 0>>group position

Hope this helps.

Regards,
Handy

cells value in grouping columns

vangeloni — Fri, 02 Oct 2009 10:06:35 GMT

Hi,

I get the cells with

var celObj= rowObj.GetCells();

anyway in that collection I do not find the cell related to column related to the group.

For example I have a webgrid with four column:

name, age, city, job

when I select a row i can get all cells for the row.

If I group by the city when I select a row i find only the cells for name, age, job.

How to get the information about the grouping column cell city?

Thanks,

Vince

cells value in grouping columns

handy@intersoftpt.com — Thu, 01 Oct 2009 22:41:43 GMT

You can get the cell (value,text, attributes) by using these codes:

var grid= ISGetObject("WebGrid1");
var selObj= grid.GetSelectedObject();
var rowObj= selObj.ToRowObject();
var celObj= rowObj.GetCells();

then, fill celObj with index number such as celObj[0];
You can get each cells value by filling the index number.

Or

You can get the information OnRowSelect event by got the row object first.

var celObj= wgGetRowByElement(rowEl).GetCells();

Also, here is the code to get the first group's row element via button click. Hope this helps.

function doButtonClick()
{ 
    //get the grid object
    var grid = ISGetObject("WebGrid1"); 
    //make sure the grid is grouped
    if (grid.RootTable.GroupedColumns.length > 0) 
    { 
        //get the first group row element
        var firstGroupRow = wgGetRowByGroup(grid.RootTable.GetElement(WG40.BODY,WG40.HTMLTABLE),0,0); 
        alert(firstGroupRow.innerText); 
    }
}

cells value in grouping columns

vangeloni — Thu, 01 Oct 2009 15:28:51 GMT

Hi,

i have a webgrid with allow grouping columns, when I group by a column how to get the cell (value, text, attributes...) related to a column grouped, because I get the selected row but when I try to get the cell related to a column grouped I got null, instead i need to get that cell.

Thanks,

Vince