Grouped fields bugs when pivot table has dynamic data

[John]

When the date grouped fields use Date Time values (and formatted through Internationalization), when dynamic data changes the >2 grouped fields are reset to only one e.g. Years, Months -> Months, or whichever is last and as observed has not been suffixed (e.g. Created_date_group_years gets removed, original field Created stays). The remaining field is duplicated in the pivot table. As seen below there are now two entries of Jun.
​

[AngelinFaithSheeba PaulvannanRajadurai]

Hi John,

We have checked the reported issue by grouping the date field and applied formatting through internationalization and the pivot table updates properly while dynamically changing the data at your end. However, we have shared the sample that we have checked for your reference.

Sample: https://stackblitz.com/edit/react-avrust-dlyeu3?file=index.js,pivot-data%2FgData.json

Output screenshot:

Initial rendering:

After dynamically updating the data using external button click:

However, If the problem persists, please reproduce it in the provided sample and revert to us (or) send your runnable sample that reproduces the problem. This would allow us to investigate the reported problem at our end and provide a solution as soon as possible.

Regards,

Angelin Faith Sheeba.

[John]

Hi, it seems like it's related to the fixed Field List Component, as reproduced in this code sample:
https://stackblitz.com/edit/react-avrust-xdr525?file=index.js

The field list load, populate methods were taken from previous correspondences on how to make the separate field list work. The field list doesn't work well without it.

[Sridhar Karunakaran]

Hi John,

Thanks for the provided sample. We were able to reproduce the reported issue on our end, and we have considered this issue as a bug titled "Grouping not applied properly when dynamically updating the data source with the static field list". This issue fix will be included in our first weekly release in July, which is scheduled to roll out on July 3, 2024. You can track the status using the feedback link below.

Feedback: https://www.syncfusion.com/feedback/58651/grouping-not-applied-properly-when-dynamically-updating-the-data-source-with-the

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization.”

We appreciate your patience until then.

Regards,

Sridhar Karunakaran

[Sridhar Karunakaran]

Hi John,

Sorry for the inconvenience. We resolved the reported issue “Grouping not applied properly when dynamically updating the data source with the static field list”, but we are unable to deliver the issue fix as promised because we are currently testing the fix with various scenarios. However, we can assure you that this issue fix will be included in our upcoming weekly release which is estimated to roll out on July 9, 2024. However, You can track the status with the feedback link below.

Feedback:  https://www.syncfusion.com/feedback/58651/grouping-not-applied-properly-when-dynamically-updating-the-data-source-with-the

We appreciate your patience until then.

Regards,

Sridhar Karunakaran.

[AngelinFaithSheeba PaulvannanRajadurai]

Hi John,

Thank you for your patience. We are glad to announce that our weekly release, V26.1.41 has been rolled out, and the fix for the reported issue, “Grouping not applied properly when dynamically updating the data source with the static field list” has been included in this release. Additionally, we have prepared a sample with the latest version for your reference.

Sample: https://stackblitz.com/edit/react-cyvnnn-nlbvzs?file=index.js,pivot-data%2FgData.json

Output screenshot:

Grouping not updated After dynamically updated the data source using external button click.

Issue root cause:
The reported issue occurred by an internal property "groupingFields" in the engine module not being properly cleared while updating the data source. This issue has been resolved by properly clearing the "groupingFields" while dynamically updating the data source.

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,

Angelin Faith Sheeba.