We have updated WebDataRocks EULA, effective as of April 18, 2024. Learn more about what's changed.

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