Hierarchical binding

[Rafael]

Hello,

I am trying to show hierarchical data on my grid, but I am always getting "no data":

I am getting my list as nested from api, like this:

So, I saw this post: https://www.syncfusion.com/forums/142685/simple-question-for-hierarchical-grid and I am trying to do like that:

Do you know what I am forgetting here? 

Thank you

[Manivel Sellamuthu]

Hi Rafael, 

Greetings from Syncfusion support. 

From your query, we can understand that you are using Hierarchy Grid. But getting no records to display in the Childgrid. In most of the cases the issue will be “QueryString field data of childgrid may not be matched in the QueryString field data of childgrid”. Also from the code example in the load event you have used ‘servicos field’ from the parent data. Please Ensure that the fields defined in queryString or Load event has the matched values.  

Documentation: https://ej2.syncfusion.com/angular/documentation/grid/hierarchy-grid/#hierarchical-binding 

Please let us know, if you need further assistance. 

Regards, 

Manivel 

[Rafael]

Hello Manivel,

Look the json:

And on queryString property I define "idContrato" too:

This is the reason I cant understand why this child grid just don't load nothing. Am I forgetting something?

Thank you

[Manivel Sellamuthu]

Hi Rafael, 

Thanks for your update. 

Since you have modified the queryString value in load event, now the ChildGrid will check the ‘Servicos’ value is matched in the parent and child grids or not. So the ‘idContrato’ value will be ignored. So we suggest you to remove the load event of the childgrid or Please ensure “‘Servicos’” field value matched in parent and childgrid records. 

Regards, 

Manivel 

[Rafael]

Hello Manivel,

I got it mapping all services(servicos) of my objects in a separated array. But with more than 3000 rows of data and hierarchy when I tried to export to excel didn't work.

But I think it's normal to not work because would be hard export more than 3000 rows with childs to excel. Maybe if you have a solution for this, could you notify me here?

If don't, you can close this ticket. Thank you very much.

[Manivel Sellamuthu]

Hi Rafael, 

Thanks for your update. 

We are glad that the provided suggestion helped and hierarchy Grid is working now.  

Regarding the excel export, By default in EJ2 Grid the Excel exporting works based on the string manipulation. While using large amount of data( Ex: 3K rows and  6 columns then total cells count as 18,000 ) in Grid then it will take considerable time to export the excel document in Grid. For these large amount of data should be exported server side only. Currently we do not have support for exporting hierarchy grid in the server side. So it is not feasible to achieve your requirement. 

Please let us know if you need further assistance. 

Regards, 

Manivel 

[Rafael]

Hello Manivel,

No problem, thank you very much for answering and clarifying about it :D

[Manivel Sellamuthu]

Hi Rafael,  

Thanks for your update.  

Please let us know, if you need further assistance.  

Regards,  

Manivel