How to refresh the data in the grid

Resolved

Hello all,

First of all, great job on this component which is very powerful and interesting.

I have been playing with an implementation where I source data from a remote CSV that is working well.
var pivot = new WebDataRocks({
container: “#wdr-component”,
toolbar: true,
height:”100%”,
width:”100%”,
report: {
dataSource: {
filename: “http://localhost:5000/test_data”,
fieldSeparator: “,”
}
}
});

I would like to refresh the data at runtime, right now the only way I found to do it is to do 
pivot.load(“http://localhost:5000/test_report”);

but that refreshes the whole data and loses filters etc…

Is there a way to refresh just the data ? I see methods like refresh() and updateData() but I can’t get them to do anything

Thanks in advance

1 answer

WebDataRocks Team WebDataRocks May 10, 2018

Hello,
Thank you for your question!
updateData method seems to suit your needs, it connects to a new data source whereas filtering, sorting, etc. remains the same. This method has the following signature:

webdatarocks.updateData(newDataSource:Object)

Here is a live sample demonstrating how it works: https://codepen.io/webdatarocks/pen/bMvKeN
Waiting to hear from you.
Thanks