Intersoft Community - WebGrid Enterprise - Only Getting First Row On Client Side Of Self Referencing Grid

Only Getting First Row On Client Side Of Self Referencing Grid

handy@intersoftpt.com — Wed, 23 Jun 2010 00:59:30 GMT

Thanks, we appreciate it much.

Regards,
Handy

Only Getting First Row On Client Side Of Self Referencing Grid

PRISMAY — Tue, 22 Jun 2010 08:30:07 GMT

Okay, thanks Handy. Yeah, I posted it as a request separately since it was off topic in this thread and figured others who want the feature can chime in. ;)

Only Getting First Row On Client Side Of Self Referencing Grid

handy@intersoftpt.com — Mon, 21 Jun 2010 22:43:37 GMT

Hello Yousif,

Unfortunately, there is no workaround for now. Even though we can access all data in dataset, the export itself uses ActiveReports engine. It needs to be enhanced from Active reports first. I already saw that you post the request in another thread. It will be forwarded to our developer teams. Thank you.

Regards,
Handy

Only Getting First Row On Client Side Of Self Referencing Grid

PRISMAY — Mon, 21 Jun 2010 08:19:17 GMT

Is there a workaround I can apply in the server-side code in the OnExport? I have access to all the data in the data set. What about the export itself, i.e., is there an API I can call and pass the data set to get the data in the format requested or something similar? Thank you.

Only Getting First Row On Client Side Of Self Referencing Grid

handy@intersoftpt.com — Sun, 20 Jun 2010 22:13:19 GMT

Hi Yousif,

Unfortunately, our current export does not support for Self-Reference grid right now.

Regards,
Handy

Only Getting First Row On Client Side Of Self Referencing Grid

PRISMAY — Fri, 18 Jun 2010 12:09:05 GMT

How do I export the visible rows? My grid initially displays 3 parent rows. I then expand several rows, but when I export, it only exports the 3 initial rows? How do you recommend I get the export to include all the visible/expanded rows?

I do have the OnExport overriden already to help export the extra loaded rows from our normal grids, but am not sure how to customize it for a self-referencing grid.

Only Getting First Row On Client Side Of Self Referencing Grid

PRISMAY — Fri, 18 Jun 2010 09:53:38 GMT

Hello Handy,

Okay, that's what I was looking for. I'll give that a try. Thank you.

Only Getting First Row On Client Side Of Self Referencing Grid

handy@intersoftpt.com — Fri, 18 Jun 2010 09:52:22 GMT

Hello,

This is a default behaviour in SelfReference scenario because the self child row only refer into a parent row. That's why it is count as one.

However, if you want, you can calculate them manually. We have GetSelfRefChildRows() method in a row object. You can get the row object by getting selected row or loop the root table for each row manually.

Example, grid.RootTable.GetRow(0).GetSelfRefChildRows();

Hope this helps.

Regards,
Handy

Only Getting First Row On Client Side Of Self Referencing Grid

PRISMAY — Fri, 18 Jun 2010 09:22:58 GMT

I just found why this is the way it is. It looks like that even though the TotalLoadedRows is 3, in this example, there are more rows loaded as the children. The 3 parent VISIBLE rows are not necessarily at positions 0, 1 and 2 respectively due to the children being at their respective positions.

Short of writing my own custom property to contain the total number of rows in the data set, how would I determine the ACTUAL number of rows loaded on the client side? Even though I may only see 3 initially, there may be hundreds loaded as children. So how do I get that number?

I need to know so I can loop through the correct number of items and get the items I need per the code above. Thank you.

[EDIT] I found one more issue. When we do expand a parent row, let's say it has 4 child rows, the TotalLoadedRows stays at 3 as it does not get updated to 7 which would be the correct number of loaded rows now.

Only Getting First Row On Client Side Of Self Referencing Grid

PRISMAY — Fri, 18 Jun 2010 08:57:15 GMT

We just started using self referencing grids and are running into the following issue. The code below only returns one valid row, the first one. After that all GetRow() calls return null. We are in a bind as we need the rows collection so any assistance to resolve this quickly is much appreciated.

Client side JavaScript to retrieve the rows (works fine with normal grids):

// TotalLoadedRows is correct
var iRows = oGrid.TotalLoadedRows;
var arRows = null;

for (var i=0; i < iRows; i++)
{
   // this line returns a valid object only when i is 0,
   // after that, returns null for remaining calls
   var oRow = oGrid.RootTable.GetRow(i);
   if (oRow == null)
   {
      continue;
   }

   if (i == 0)
   {
      arRows = new Array();
   }


   arRows.push(oRow);
}