Need solution for rapid data entry involving hierarchical data

[Jason Burkybile]

What would you suggest is the best option for quickly editing hierarchical data that will have detail data with a different schema (different columns)?

The hierarchy grid with batch edit was the closest thing to what we need. But it doesn't work because the batch editing context for each grid is independent. Syncfusion support noted that the batch edit grid needs to be saved before the detail is collapsed, but we want the user to be able to edit any cell and save/update as a whole, not just one grid at a time. Also had issues with detail row not being able to expand or collapse when editing a row. See notes and attached code.

Hierarchy Grid with Batch Edit

Request

We need the ability to maintain a batch edit across all nested grids, but the batch edit context (and the grid) gets reset once the nested grid is collapsed.

Steps to reproduce

• Expand a row
• Edit a child record
• Note that the batch edit shows which fields were edited
• Collapse the row with the grid that you just edited
• Expand the row with the grid that you just edited
• Note that the batch edit state/context is gone as you can see the child grid doesn't remember our edits

Attachment: Sprbrk.Demo_8bf1119a.7z

[Jeevakanth Palaniappan]

Hi Jason, 

Greetings from Syncfusion support. 

We have checked your query and we are currently checking the feasibility of your requirement from our side. So we will update the further details in two business days. Until then we appreciate your patience. 

Regards, 

Jeevakanth SP. 

[Jeevakanth Palaniappan]

Hi Jason, 

 

Thanks for your patience. 

 

Query 1: we want the user to be able to edit any cell and save/update as a whole, not just one grid at a time 

 

We have checked your query and we would like to inform you that the every grid is rendered as a separate component and every grid will be having different Grid reference and Edit Context. So it is not possible to update the records as a whole. But your scenario seems to be similar to the tree grid component. So we suggest you to refer the below link whether it matches your requirement. 

 

https://blazor.syncfusion.com/demos/tree-grid/batch-editing?theme=bootstrap4 

https://blazor.syncfusion.com/documentation/treegrid/edit#cell 

 

Query 2: not being able to expand or collapse when editing a row 

 

We have validated and considered the reported problem as a bug and logged the defect report “Need to close/save the edited cell when clicking on the Expand/Collapse icon” for the same. Thank you for taking the time to report this issue and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle) and including the fix by the end of September 2021. Until then we appreciate your patience. 

 

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

https://www.syncfusion.com/feedback/28484/need-to-close-save-the-edited-cell-when-clicking-on-the-expand-collapse-icon 

 

Query 3: Batch edit context (and the grid) gets reset once the nested grid is collapsed. 

 

Based on your query we suspect two scenario’s. Please kindly confirm the exact scenario. 

 

1. Do you want to save the nested grid when you click on the Expand/Collapse icon?
2. Do you want to maintain the edited data which is highlighted in the nested grid. If this is your scenario, then we would like to inform you that the edited data will be shown only in the UI and it is not yet updated in the datasource. It will be updated only when you click on Update icon in the corresponding grid toolbar. The grid will be re-rendered when expanding the grid. So this is not possible to maintain the edited data when expanding the already edited grid.

 

Kindly confirm us the above scenario to proceed further. 

 

Regards, 

Jeevakanth SP. 

[Jason Burkybile]

1. Do you want to save the nested grid when you click on the Expand/Collapse icon?

Yes, this would be very helpful.

[Jeevakanth Palaniappan]

Hi Jason, 

Thanks for sharing the requested details. 

We have forwarded your query to the corresponding development team and so we will update the further details in two business days(on or before Sep 14, 2021). Until then we appreciate your patience. 

Regards, 

Jeevakanth SP. 

[Jeevakanth Palaniappan]

Hi Jason, 

Thanks for your patience. 

Currently we do not have support to save the edited data when collapsing the detail template. We have considered this requirement as an usability improvement feature and logged the improvement report for the same. Thank you for taking the time to request this improvement “Need to provide an event when collapsing the Detail template” and helping us improve our product. At Syncfusion, we are committed to fixing all validated defects (subject to technological feasibility and Product Development Life Cycle ) and including the improvement feature in our Patch release which is expected to be rolled out by the end of October 2021. Until then we appreciate your patience. 

   

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

  

https://www.syncfusion.com/feedback/28636/need-to-provide-an-event-when-collapsing-the-detail-template 

After providing an event, your requirement will be achieved by invoking the EndEdit method of the grid. Here the grid reference will be set in Sictionary<int, SfGrid<Comment>> . The parent record should have the unique values (like primary key) to set a unique grid reference. Below are the POC code snippet for your reference. 

<GridTemplates> 

        <DetailTemplate Context="level1"> 

                    <SfGrid @ref="myComponents[id]" DataSource="row.Comments"> 

.. 

.. 

<GridTemplates> 

private Dictionary<int, SfGrid<Comment>> myComponents = new Dictionary<int, SfGrid<Comment>>(); 

public async Task Save() { 

        await myComponents[id].EndEdit(); 

    } 

Regards, 

Jeevakanth SP. 

[Vignesh Natarajan]

Hi Jason,  

 

We have analyzed your query and we do not have support for your requirement. We have already logged an feature request task for this requirement “Need to provide an event when collapsing the Detail template”. At the planning stage for every release cycle, we review all open features and identify features for implementation based on specific parameters including product vision and technological feasibility.  

  

You can now track the current status of this feature request from the below feedback page.    

 

https://www.syncfusion.com/feedback/28636/need-to-provide-an-event-when-collapsing-the-detail-template  

    

You can also communicate with us regarding the open features any time using our above feedback report page. We do not have immediate plan to implement this feature and it will be included in any of our upcoming releases. Please cast your vote to make it count. So that we will prioritize the features for every release based on demands. 

 

Please let us know if you have any concerns. 

 

Regards, 

Vignesh Natarajan