Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Custom Data Source

Answered
Sengupta asked 7 days ago

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
});
}
 

3 answers

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 5 days ago

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 2 days ago

@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 11 hours ago

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

Please login or Register to Submit Answer