Need a special offer?Find out if your project fits.
+

Issues with Expand Columns or Rows or All and with Collapse Columns or Rows

Answered
sedApta asked on May 8, 2024

Hello all,

I have come in need to configure a pivot grid able to expand/collapse only rows or columns or all together, and I have found quite some issues.
As long as I have to only expand (wathever it might be from only rows, columns or all), I can use your expandAllData function, which works almost for every test case. And here comes my first issue:

If I have configured a pivot grid with a hierarchy field (which contains at least two levels of hierarchy) and a second node field following the hierarchy one, once I click the expand all button, which fires your
expandAllData function, the pivot drills down all the hierarchies but does not open the last node field. This happens the same even trying to call expandAllData(true, "columns"), for reference.
This behaviour is the same both for api and json datasource type.

My second issue is the following one, which happens only for the api datasource type grid:
I have configured a pivot grid, with the same configuration as above. If I manually open the hierarchy levels in the columns and afterward proceed to close them,
wether by the collapse all button (which fires your collapseAllData function) wether it is manually, the grid seems to remember the last hierarchy level manually opened and when I try to open again the hierarchy levels right
from the start the grid opens all of them hierarchies until the last one opened by me.
This behaviour is kind of misleading to me. I expect that if I drill up all the levels, when I try to open them again I have to go through every level all over from the start.
As said, this happens only for the api datasource type, for the json datasource type it works fine.

As per my third issue:
I have configured a pivot grid, with the same configuration as above. If I click on the expand columns button, which for reference fires your expandAllData(true, "columns") function, the grid acts in a strange way..
meaning that it does open all the levels in the columns (except for the first issue related nodes) and at the same time it tries to open some rows levels too, apparently in a complete random way.
This behaviour happens clearly in the json type datasource. As per the api type datasource, it tries to open the row levels too and you can see that as some icons go from closed to opened position.
Note that this does not happen if you exchange the columns data to the rows and viceversa, this only happens with the configuration provided, so hierarchy levels in columns and nodes in rows.

And for my fourth and last issue:
I had to implement my own solution for collapse rows/columns, ever since there is not an opposite function to expandAllData which can close only rows or only columns. I could not even use runQuery or refresh,
since they do not update the expands and drills object contained in the slice.

I will provide an example where you can see my workaround, which just manipulate these objects in the slice and then proceed to
reassign the report itself, which I don't like to be honest.

Is there a possibility for you to implement somenthing as collapseAllData(withChildren?: boolean, axis: string)? I know your collapseAllData function exists but it does not help me in this case.

I will attach a solution where you can reproduce these issues, with both api and json datasource type.

I hope everything is clear and readable.
Thank you and hoping to hear from you soon.

Edinson

 

Attachments:
expandCollaseIssues

5 answers

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 9, 2024

Hello, Edinson!

Thank you for contacting us and providing a project with reproducible issues.

We have reproduced all the described expanding and collapsing behavior on our side. Our Dev team will look closely at the provided cases and get back to you with two fixes:

  • The behavior of the expandAllData(true, "columns") with multilevel hierarchies in columns described in issues 1 and 3 will be fixed with the ETA May 27th.
  • The fix for the issue 2 with collapseAllData() API call, where more fields are expanded after the collapse in custom data source API, would be fixed with an ETA June 10th. After the fix, the behavior of expands in the custom data source API would match the one in the JSON data source.

Regarding your request to collapse all columns and all rows separately in collapseAllData(), we need to discuss the matter with our Development team. We'll get back to you with the updates on this question in a few days.

Hope you will find our answer helpful.

Kind regards,
Solomiia

Public
sedApta May 10, 2024

Hello Solomiia,

Thank you for your quick answer!

I will forward your answer to my dev team in order to adapt our timeline within your indications.

Hoping you guys a good day!

Best regards,

Edinson

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster May 10, 2024

Hello, Edinson!

Thank you for your swift response.

Regarding your request for collapseAllData() for columns and rows separately, we have added this feature to our Customers' Wishlist. Our team will notify you about any updates on the matter.

We also wanted to explain in more detail the behavior of Flexmonster expands from your issue 2. Please note that when expanding and collapsing nodes manually, Flexmonster does remember all the expand actions made. In this case, Flexmonster won't collapse child nodes if you collapse the parent node manually.
However, when using collapseAllData(), it is expected that all child nodes will collapse. In this case, on the next expand action only the selected node will expand.
Our fix will cover the case with collapseAllData() unexpected behavior in the custom data source API, but the manual expanding functionality will remain.

Hope it helps.

Our team will notify you as soon as the fixes we discussed are ready.

Kind regards,
Solomiia

Public
sedApta May 13, 2024

Hello Solomiia!

Thank you for clarifying the manually collapsing expected behavior, just letting you know we totally agree with it.

Thank you again for the support and looking forward to hearing from you, keep up the good job!

Best regards,

Edinson

Public
Solomiia Andrusiv Solomiia Andrusiv Flexmonster 7 days ago

Hello, Edinson!

Thank you for your feedback.

We will notify you as soon as the fix is ready.

Feel free to reach out to us if any other questions arise.

Kind regards,
Solomiia

Please login or Register to Submit Answer