asked on August 27, 2024
There appears to be a bug when I have a hierarchy that has nested fields under it with multiple columns. When I expand the columns, The values for the rows under the hierarchy are $0 when they should not be. You can see in the "before.png" that there are values for all levels of the pivot. Then in the "after.png" that has the column expanded, the values are all $0 for rows under the hierarchy. I'd expect there to be values in at least one of the two columns for all the rows.
If the columns are expanded and I collapse the rows, then expand the rows, the data appears correctly. It just appears to be an issue if I expand rows first, then expand columns that the data is not correct.
⋅ August 28, 2024
Hello,
Thank you for reaching out to us.
Could you please tell us which data source you use? It would greatly help us to continue the investigation.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ August 28, 2024
Nadia,
I am using the Custom data source API. It occurs both using the Flexmonster provided nuget package as well as our own implementation.
When looking at the API requests coming from the client I don't see a "select" request with the correct combination rows and columns in the "aggs.by".
⋅ August 29, 2024
Hello Brian,
Thank you for providing us with the details.
We could not reproduce the described behavior in our sample project. Could you please provide us with the project and sample data where this issue can be reproduced?
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ September 3, 2024
I was able to reproduce it here https://jsfiddle.net/4sq5hejr/. I attached a gif of using this example to show the issue. You can see for row 9, the value for Australia is 680. When I expand the column, the values are all empty. When I expand it again the value is now not empty and contains a value.
edit: it doesn't appear to let me update the gif or mp4. I can sent it via email if you provide me with an email
⋅ September 3, 2024
Hello,
Thank you for the response.
Our team has reached out to you via email. Please check your email.
Kind regards,
Nadia
⋅ September 4, 2024
Hello,
Thank you for providing us with the details.
Our team will take a look at the described behavior and provide a fix with our minor release with the ETA September 30th. We will notify you about the release.
You are welcome to contact us if other questions arise.
Kind regards,
Nadia
⋅ September 30, 2024
Hello,
We are happy to let you know that the issue with an incorrect /select request for expands when the slice contains a multilevel hierarchy with a filter applied was fixed.
This fix is included in the 2.9.87 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-87/
You are welcome to update the component. Check out our updating tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if the fix works fine for you. Looking forward to hearing from you.
Kind regards,
Nadia
⋅ September 30, 2024
Nadia,
Thank you! I tested this and confirmed that the issue has been fixed.
Best,
Brian
⋅ October 1, 2024
Hi Brian,
Thank you for the feedback!
We are glad to hear that it works for you.
Do not hesitate to contact us if other questions arise.
Kind regards,
Nadia
