Hi Nikolay,

Thanks for the prompt response. I tried both your suggestions but the grid still doesn't render child elements.It shows only the column headers.For the second approach I modified the data source so that the json returned is:

{"page":0,

"records":922,

"rows":[{"id":359,"businessCode":"12121212","taskType":"Task","taskName":"Test","country":"DF","Status":"P","StartDate":"2012-10-23","Deadline":"",

"Activities":{"Activities":[{"ParentTaskId":0,"ProgressStatus":null,"IsProgressStatusEnabled":false , ............

Is there something still missing or misconfigured?

Thanks and regards,

Sudipto

Hi Nikolay,

Any update on this?

Thanks and regards,
Sudipto 

Hi, Sudipto.

Sorry for the little bit response. I've directly tried to modified your code but with no success for the moment. It's seems is something small that I'm missing too. That's why I get a working sample and starting from there I will start to modify it for your needs. Meanwhile you can try it also:

var adventureWorksCustomerSales = {
   "Records": [
   {
        "CustomerID":1,
        "TerritoryID":1,
        "AccountNumber":"AW00000001",
        "ModifiedDate":"\/Date(1097655307263)\/",
        "GeneratedSales":7136.9199321292353,
        "CustomerAddresses": {
              "Records": [
              {
                    "AddressID":832,
                    "AddressTypeID":3,
                    "ModifiedDate":"\/Date(996613200000)\/",
              }]
        }
    }]
}

$("#grid1").igHierarchicalGrid({
     dataSource: adventureWorksCustomerSales,
     dataSourceType: "json",
     responseDataKey: "Records",
     initialDataBindDepth: 1,
     autoGenerateColumns: false,
     primaryKey: "CustomerID",
     columns: [
         { key: "CustomerID", headerText: "CustomerID", dataType: "number" },
         { key: "TerritoryID", headerText: "TerritoryID", dataType: "number" },
         { key: "AccountNumber", headerText: "AccountNumber", dataType: "string" },
         { key: "ModifiedDate", headerText: "ModifiedDate", dataType: "date" },
         { key: "GeneratedSales", headerText: "GeneratedSales", dataType: "number" }
     ],
     autoGenerateLayouts: false,
     columnLayouts: [
     {
           key: "CustomerAddresses",
           responseDataKey: "Records",
           autoGenerateColumns: false,
           primaryKey: "AddressID",
           foreignKey: "CustomerID",
           columns: [
                   { key: "AddressID", headerText: "AddressID", dataType: "number" },
                   { key: "AddressTypeID", headerText: "AddressTypeID", dataType: "number" },
                   { key: "ModifiedDate", headerText: "ModifiedDate", dataType: "date" }
          ]
     }]
});

So please try this and I will do the same and will keep you posted.

Thanks you for the patience, Sudipto.

Best regards,

Nikolay Alipiev

Hi, Bob.

For any other issues don't hesitate to ask us and create a forum post.

Best regards,

Nikolay

Hi Nikolay,

Thanks for responding. I think it's best for me to just understand how to work with the current implementation of the igHier Grid.

In my case, I need to make several service calls to get the data I need. And since I'm receiving various collections from the service calls, I need to use server-side C# code to reorganize the data in a hierarchical manner which is fit for your grid.

so as long as I know that I need to massage my Json data a bit before rendering the Hier Grid, then that's fine.

thanks again.

Bob

Hello Nikolay,

I regards to your example JSON data here, is it possible to retrieve the "CustomerAddresses" JSON data in a completely different data set and have the igHierarchGrid discover the relationship via the primary and For keys ?

Or does it indeed have to be in this format where the Parent/Child data Json data is already in place as in your example below ?

var adventureWorksCustomerSales = {
   "Records": [
   {
        "CustomerID":1,
        "TerritoryID":1,
        "AccountNumber":"AW00000001",
        "ModifiedDate":"\/Date(1097655307263)\/",
        "GeneratedSales":7136.9199321292353,
        "CustomerAddresses": {
              "Records": [
              {
                    "AddressID":832,
                    "AddressTypeID":3,
                    "ModifiedDate":"\/Date(996613200000)\/",
              }]
        }
    }]
}

ex/ In other words could I have these two datasets as follows ?

  "Records": [
   {
        "CustomerID":1,
        "TerritoryID":1,
        "AccountNumber":"AW00000001",
        "ModifiedDate":"\/Date(1097655307263)\/",
        "GeneratedSales":7136.9199321292353
    }]
}

      "CustomerAddresses": {
              "Records": [
              {

                    "CustomerID":1,
                    "AddressID":832,
                    "AddressTypeID":3,
                    "ModifiedDate":"\/Date(996613200000)\/",
              }]
        }
 

Hi Nikolay,

Your proposed solution worked . Thanks a lot for your help.

Regards,

Sudipto