🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all hot features!
Get Free Trial

Added record not visible if parent node is expanded

Ilaria asked on June 26, 2019

I have an issue using ‘updateData’ API to add a new record. In some case the record is not visible in the pivot after calling updateData (although the aggregate value sum is correctly updated).
It seems to happen when:

  • there are more than 100 records in the data source
  • there are at least two level of aggregation (for rows)
  • there is at least one node expanded (no matter whether the expanded node is the one with the new record or not). 
  • the added record has a value (for the lower level) that is not yet in the pivot.

I prepared a JSFiddle in which you can choose the number of record in the data source. 

  • ‘Add exist product’ works fine, no matter the number of record or the expand/collapse state.
  • ‘Add new product’ works only if you never expand a node or if the datasource has less than 100 records

Could you please fix it?
Thank you!
Best regards,

3 answers

Tanya Gryshko Tanya Gryshko Flexmonster June 26, 2019

Hello, Ilaria,

Thank you for reporting this issue and providing such a detailed description. It really helped us to reproduce the issue quickly.

Our development team will fix it and release an update on the 29th of July.

Please let us know in case of any other questions.


Ilaria June 27, 2019

Thank you!

Vera Didenko Vera Didenko Flexmonster July 30, 2019

Hello, Ilaria,
We are glad to inform you that the issue with not resorting optimized sorted members after calling updateData() was fixed.
This is included in the 2.7.11 version of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Feel free to write to us in case of questions.
Best Regards,

Please login or Register to Submit Answer