asked 2 days ago
Hello,
I created a custom Flexmonster API server using your example.
It works perfectly, but it removes a feature (compared to JSON mode).
We can't sort the columns in the drill-through view, which is confusing for our users.
In the flat view, we can sort the columns, as well as in the pivot table view.
From what I understand, the reason is that in custom API mode, the cube paginates and does not have all the data needed to sort, so the sort option is not available in the UI.
Do you have a solution?
Is this feature planned for future versions?
Best regards,
Florent Odievre
⋅ 19 hours ago
Hello, Florent!
Thank you for reaching out to us.
Please note that column sorting in the drill-through view is currently available only for JSON and CSV data sources, where all data is loaded into the browser's memory. At the moment, there is no workaround to enable sorting in the drill-through view for custom data source API - the data rows are displayed in the order returned by the server.
We have added your request for drill-through column sorting support in the custom data source API to our Customers' Wishlist. Our team will keep you informed of any updates regarding this feature.
Feel free to reach out to us in case of any other questions.
Kind regards,
Solomiia
