Intersoft Community - WebGrid Enterprise - How to access the child rows under a parent row in hierarchal grid group by scenarios

How to access the child rows under a parent row in hierarchal grid group by scenarios

handy@intersoftpt.com — Wed, 07 Dec 2011 03:36:35 GMT

Hello Suhas,

Based on your description, I tried to load WebGrid based on saved xml. When I looked up into GetRowsCount, it shows the correct result for multiple times. Perhaps, there are something I missed. Can you provide me a simple runable sample that replicates this issue? Perhaps, your structure is required.
But I still need it to be runable in order to debug and anlayze the issue.

Regards,
Handy

How to access the child rows under a parent row in hierarchal grid group by scenarios

suhastj — Tue, 06 Dec 2011 05:29:40 GMT

Thanks for the replay.

There is a bug in ISWebgrid that has been posted and also accepted by Intersoft. The bug is, when ever a check is enabled for each row, after checking a row if we perform any sort of operations like Group by field or box, the checks are not retained. This issue is present only in hierarchecal grid. So we can replicate this issue only in 2nd level rows onwards.

In order to have a work around until Iswebgrid come up with a fix, i have stored the Web grid row information as an xml. When ever a post back happens, i have to do following operations

1. Read the Xml and and based on the information check the rows from client side.

2. If the row was expanded by user, it has to be expanded as well.

3. If the group row is present, i need to maintain the group row as well.

In order to resolve the hierarchecal grid scenario i have a method as shown.

function RecursiveCheckRow(xmlData,gridRootTable,isFirstCall) {
  var count = gridRootTable.GetRowsCount();
  for(i=0;i<count;i++) {
     var canBeChecked=false;
     var row = null;
     if(isFirstCall)
        row = gridRootTable.GetRow(i);
     else
        row = gridRootTable.GetChildRow(rowIter);

     // Identify each row and if the row needs to be checked, 
     // Mark it as "can be checked".
     if(canBeChecked) {
        row.Check();
        // If row has child rows, call the same method resursively
        RecursiveCheckRow(xml,row,false);
     }
  }

}

In first call i will get the count but in second call onwards i will not get the count. I tried

rowCount = gridRootTable.GetChildRows().length; and it worked but i need to know what all API's i can use from client side to get the row count. Some times, gridRootTable.GetChildRows().length returns 1, even if the row has multiple child rows.

Please let me know, if explains what you are looking for?

Thanks,

Suhas

How to access the child rows under a parent row in hierarchal grid group by scenarios

handy@intersoftpt.com — Tue, 06 Dec 2011 02:08:29 GMT

Hello Suhas,

There are several ways to use RowsCount method. However, I would like to know your code snippet first.
e.g If I simply use WebGrid1.RootTable.GetRowsCount(), it would not show error. In your code, you used API row. What exactly this API row?

Regards,
Handy

How to access the child rows under a parent row in hierarchal grid group by scenarios

suhastj — Fri, 02 Dec 2011 01:59:23 GMT

Hi,

Can any one please tell me how to perform follwoing actions.

I have attached the screen shot of the Hierarchal grid structure in attachments. Based on that i have following doubts. I need Client side events/ methods for the following.

1. When i group based on a column (In screen capture the column is process id), i want to get all the rows under a row.

With respect to the screen capture (With group by enabled), i want to get all the row whos wo_id = "100" from client side.

2. I want to get the count of child rows. Say how many rows are present under the row with wo_id = 100.

3. I want to expand the top most group.

NOTE:

When i use the API row.GetRowsCount();, I will get an exception and it is only in group by scenario. In normal scenario, it works fine.

"Unable to get value of the property 'tagName': object is null or undefined"

Please share your ideas on how to achieve the above scenarios when i group the columns.

Thanks in advance,

Suhas T J