We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Treegrid Flat Data with party no children

Hello,

I have a flat JSON data, which I want to be presented in the Treegrid.
The entries have partly children (works with idMapping and parentIdMapping), but some entries are on level0 and have no children (parentId is here 0).
These entries are not shown at all, only the ones with children. Is there a way to achieve this?

Thanks,
Martin

10 Replies

PK Padmavathy Kamalanathan Syncfusion Team September 2, 2019 01:26 PM UTC

Hi Martin, 

Thanks for contacting Syncfusion Forums. 

QUERY: Records with no children (parented as 0) is not shown in TreeGrid 
 
From your query we understand that you have issue with displaying records which doesn’t have parent record. We suggest you to set parenteId as null to those record which doesn’t have parent.   

Please refer the below sample, 

In the above sample, Task ID 2’s parentD is set to null. 

Please refer the below screenshot, 

 

If you have further queries, please get back to us. 
 
Regards, 
Padmavathy Kamalanathan 



MF Martin Frühmorgen September 3, 2019 10:04 AM UTC

Thanks a lot! That works perfectly!

Do you have an example with flat JSON data in Treegrid and Row Drag and Drop?

Thanks again,
Martin


PK Padmavathy Kamalanathan Syncfusion Team September 4, 2019 09:28 AM UTC

Hi Martin, 

Thanks for the update. 

QUERY: Sample for Row Drag and Drop of TreeGrid 
 
As per your request we have created sample and shared you here. 

Please find the below Sample, 

Please find the below help documentation, 

If you have further queries, please get back to us. 

Regards, 
Padmavathy Kamalanathan 



MF Martin Frühmorgen September 4, 2019 09:37 AM UTC

Hello, and thanks for the sample.
The issue is that the rows are copied and not moved after dragging. In other samples with hierarchical data, the row are just moved.

Thanks!
Martin


PK Padmavathy Kamalanathan Syncfusion Team September 6, 2019 02:11 AM UTC

Hi Martin, 

We are able to reproduce the reported issue at our end. We are validating your query. We will get back to you with the solution on 9th September 2019. 

Till then we appreciate your patience. 

Regards, 
Padmavathy Kamalanathan 



MF Martin Frühmorgen September 11, 2019 03:19 PM UTC

Hallo,

any news on this?

Thanks!
Martin


PK Padmavathy Kamalanathan Syncfusion Team September 12, 2019 08:58 AM UTC

Hi Martin, 

Sorry for the delay. 

QUERY: Issue with Row Drag and Drop of TreeGrid with Self reference data 
 
We have validated the defect you have initiated with us. Thank you for the taking the time to report the issue and helping us improve our product. At Syncfusion we are committed to fixing all the validated defect (subject to technological feasibility and Product Development Life Cycle) and including its fix in our subsequent release. So fix for the issue will be included in our Volume 3 release which is expected to be rolled out at the end of September 2019. 

You can track the current status of your request, review the resolution timeline and contact us for any further inquiries through this link.  

Note: To view the above feedback, kindly login into your account.  

Disclaimer: The feedback link is in review state and you can check it once it is validated 

If you have further queries, please get back to us. 

Regards, 
Padmavathy Kamalanathan 




PK Padmavathy Kamalanathan Syncfusion Team October 10, 2019 10:12 AM UTC

Hi Martin, 

We are glad to announce that our Essential Studio Volume 3, 2019 release (v17.3.0.14) is rolled out and is available for download under the following link. 

We have also included fix for the reported issue, ‘Issue in Row Drag and Drop of TreeGrid with self reference data’ with this release. 
  
We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

Regards, 
Padmavathy Kamalanathan 



MF Martin Frühmorgen November 28, 2019 06:14 PM UTC

Hello,

I have another question regarding the Treegrid in Vue.

I have hierarchical data with some amount of currency in one field and would like to aggregate this amount in a sum footer.
If I use the the standard sum footer, the parent and child entries are summed up.
But the parent record reflects already the summed up amount of the childs. Therefore the footer displays the wrong amount.
How to achieve a way to have only the childs summed up?

f.e. 
1     2000
1.1    1800
1.2      200

2     3200
2.1     1200
2.1.1     1000
2.1.2     200
2.2     2000

------------
footer aggregate: 5200


Another question is spanned headers.
I would like to have several spanned headers with programmatically changes. This means I add 3 columns with a new span header while preserving the old ones.

HEADER 1          HEADER 2
col 1     col2          col 3     col4

If I do it in Vue like this
var columnsresult = self.$refs.leistungsstandtreegrid.$el.ej2_instances[0].getColumns()

columnsresult.push({
field: headerstring,
columns: [ { field: realwertstring, headerText: 'Realwert' },
{ field: prozentstring, headerText: '%' },
{ field: summestring, headerText: 'Summe' }]
})
self.$refs.leistungsstandtreegrid.$el.ej2_instances[0].columns = columnsresult
self.$refs.leistungsstandtreegrid.$el.ej2_instances[0].refreshColumns()
self.$refs.leistungsstandtreegrid.$el.ej2_instances[0].refreshHeader()
the old spanned headers disappear.

Thanks a lot for your help!
Martin


PK Padmavathy Kamalanathan Syncfusion Team November 30, 2019 05:32 AM UTC

Hi Martin,

Thanks for contacting Syncfusion Forums.


QUERY1: Issue with stacked header

We have validated the defect you have initiated with us. Thank you for taking the time to report the issue and helping us improve our product. At Syncfusion we are committed to fixing all the validated defect (subject to technological feasibility and Product Development Life Cycle) and including its fix in our subsequent release. So fix for the issue will be included in our upcoming Volume 4 Main release which is expected to be rolled out in the mid of  December 2019.

You can track the current status of your request, review the resolution timeline and contact us for any further inquiries through this link


Note: To view the above feedback, kindly login into your account.

QUERY2: Issue with Summary Aggregate 

From your query we understand that the Sum Footer has both parent and child value summed. We sum both parent and child in Sum since it's total Sum. Competitors also follow the same. But in order to achieve your requirement we suggest you to use custom Aggregate. In Custom Aggregate, you can calculate parent value alone and display it in footer template.

Please check the below sample,

Please check below help documentations,

If you have further queries, please get back to us.

Regards,
Padmavathy Kamalanathan


Loader.
Live Chat Icon For mobile
Up arrow icon