Get Free Trial

Custom Data Source

Closed
Sengupta asked on April 29, 2021

Hi
FM version – Feb 2021 v 2.8.27
We have changed our Data Source from JSON type to API type (Custom Data Source)
In our previous version of FM (2.327 with JSON type) when we used to refresh data using pivot.updateData, we passed a parameter “keepMembersOrder: true” to stop the report from resorting with updated data
If we do the same for CDS it doesn’t work, please help

function refreshCustomData() {
pivot.updateData({
type: “api”,
url: “http://……”,
index: “data-set-1”
},
{
keepMembersOrder: true,
ignoreScroll: false
});
}
 

8 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster April 30, 2021

Hello,
 
Thank you for reaching out to us.
 
Please make sure the index specified in the `updateData` method is the same as the one currently used in the component. Otherwise, the scroll will be ignored.
 
We hope it helps.
Feel free to contact us in case other questions arise.

Regards,
Illia

Public
Sengupta May 4, 2021

@Illia 
I am pretty sure the index never changed but the pivot re sorted on flexmonster.updateData
kindly see the attached screenshots
You prepared a JSFiddle example (http://jsfiddle.net/flexmonster/r2kt5s36/) for me for another query regarding “updateData”
https://www.flexmonster.com/question/flexmonster-custom-data-source-api-reload-data/
If you could kindly alter the data heavily on refreshCustomData then you may be able to re create the issue
I have no way to alter the data in https://olap.flexmonster.com:9500 for you

Attachments:
Sort1.PNG
sort2.PNG

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 5, 2021

Hello,
 
Thank you for the clarification.
 
Our team will research possible solutions for keeping members’ order when using the custom data source API. We will get back with the results ETA June 14.
 
Do not hesitate to contact us if other questions arise.
 
Regards,
Illia

Public
Sengupta June 9, 2021

@Illia Yatsyshyn
Could you please kindly confirm that the solution will be a patch for 2.8 and not just in the new release 2.9

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 9, 2021

Hello,
 
Thank you for your question.
 
Please note that version 2.8.33 was the latest minor of the 2.8. From now on, all the minor updates will be released in version 2.9. It includes upcoming fixes discussed in the current thread.
 
We recommend migrating to major version 2.9 in order to keep getting the latest features and fixes. Please note that in most cases updating to 2.9 will not differ from updating to the minor version due to the backward compatibility of our newest release. Still, we suggest checking our migration guide to make sure no additional changes are needed before the update.
 
Feel free to reach out if any additional questions arise.
 
Kind regards,
Illia

Public
Sengupta June 14, 2021

@Illia Yatsyshyn,
Any possible solutions for “keeping members’ order” issue?

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster June 15, 2021

Hello,
 
We are happy to announce that now you can use the keepMembersOrder property when updating data from the custom data source API. This is included in the 2.9.1 version of Flexmonster.
You are welcome to update the component. Here is our updating to the latest version guide for assistance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
Please let us know if it works for you.
 
Kind regards,
Illia

Public
Sengupta July 8, 2021

@Illia Yatsyshyn
Test passed
Many thanks for fixing the issue

This question is now closed