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

[BUG] Hierarchy levels are not ordered according to result of /members request

Answered
eze@wejugo.com asked on December 16, 2020

In one of our hierarchy levels we have a custom ordering that isn’t alphabetical. When we drill into the level on the grid, or when we open the filter popup, the level members aren’t ordered according to what we returned in the /members request (with sorted: true), instead they get re-sorted alphabetically.
 
If on the other hand, we don’t use the fields as a hierarchy, our custom ordering is respected.

8 answers

Public
Vera Didenko Vera Didenko Flexmonster December 17, 2020

Hello, Ezequiel,
 
Thank you for reaching out to us and for providing JSFiddle examples. 
 
Indeed, the sorted: true property is not applied for multilevel hierarchies.
Our team will provide the fix to this issue in the minor release version with the ETA 11th of January.
 
As an alternative approach, we kindly suggest setting the defaultHierarchySortName option to "unsorted", for example:

options: {

grid: {
type: 'classic',
showGrandTotals: 'rows',
dragging: false,
},

configuratorActive: true,
configuratorButton: true,
fieldListPosition: 'right',

defaultHierarchySortName: "unsorted"
},

Here is a modified version of the JSFiddle where the ordering issue is fixed using the above approach: https://jsfiddle.net/flexmonster/gf3wpet2/
 
 
Please let us know if this works fine for you. 
Looking forward to your response.
 
Kind regards, 
Vera

Public
eze@wejugo.com December 17, 2020

Okay, that works for us! Cheers and thanks for your help

Public
Vera Didenko Vera Didenko Flexmonster January 11, 2021

Hello, Ezequiel,
 
We are glad to inform you that the issue with the presorted members in the hierarchical fields was fixed.
 
This is available in the latest minor release of Flexmonster: https://www.flexmonster.com/release-notes/.
You are welcome to update the component. Here is our updating to the latest version tutorial for guidance.
 
Please let us know if the fix works fine for you.
We would be grateful for your feedback.
 
Kind regards, 
Vera

Public
Vera Didenko Vera Didenko Flexmonster January 20, 2021

Hello, Ezequiel,
 
Our team is wondering if you’ve found the latest fix helpful. 
Please let us know if everything works fine for you.
 
We would be happy to hear your feedback.
 
Kind regards, 
Vera

Public
eze@wejugo.com January 27, 2021

Hello there, it seems to work but we have unfortunately run into a different issue that prevents us from using this new version.
Even though our custom data API implementation advertises v2.8.5 support, the updated Flexmonster component is using the new FilterGroup object to query the /members endpoint to get the hierarchy members, which leads to a error in our backend.
As it’s going to take a little while for us to upgrade our backend to be v2.8.22 compatible, we’d like to file a bug regarding respecting the handshake version.
Edit: I can confirm that this bug was introduced with version 2.8.23.

Public
Vera Didenko Vera Didenko Flexmonster January 28, 2021

Hello, Ezequiel,
 
Thank you for your response.
 
We are glad to hear that the issue with members sorting is resolved.
 
Regarding the issue with the new filter structure being used despite the handshake version:
Thank you for reporting this issue to us. We have managed to reproduce the same behavior on our end.
Our team will provide the fix in one of the upcoming minor versions of Flexmonster with the ETA 22nd of February.
 
Please let us know if this would work for you.
 
Kind regards,
Vera

Public
Vera Didenko Vera Didenko Flexmonster February 23, 2021

Hello, Ezequiel,
 
We are happy to inform you that compatibility with older versions of the custom data source API protocol was improved.
Now the new Filter Group Object is used only if the version sent in the /handshake response is 2.8.22 or later. 
 
This is available in the latest version of Flexmonster.
You are welcome to update the component. Here is our updating to the latest version guide for assistance.
 
Please let us know if the fix works fine for you.
Looking forward to your response.
 
Kind regards,
Vera

Public
Vera Didenko Vera Didenko Flexmonster March 2, 2021

Hello, Ezequiel,
 
Our team is wondering if you’ve found the latest fix helpful.
Does everything work fine for you?
 
Please let us know if the fix helped.
Looking forward to your feedback.
 
Kind regards, 
Vera

Please login or Register to Submit Answer