Filter data in DataTables and Redraw all charts

[zhx828]

Hi,

Is there anyone know how to filter data in DataTables and Redraw all charts? I combined the dataTable in dc.js and the DataTables(http://datatables.net) by adding $("dataTable").dataTable and dc.dataTable("#dataTable") at same time. Right now, it's able to redraw the data table based on the clicks of each charts. But is there anyway to do the reverse?

Peter

[jrideout]

@zhx828 You need to set some kind of onClick handler for the table that will filter on the table's dimension and then call dc.redrawAll.

[zhx828]

@jrideout Thank you for your suggestions. I add a 'Refresh Charts' button, and once user clicks it, it will get the current row id into dataTable filter, then do the redrawAll. But question is if I want to add another button 'reset', what should I do to get the original data back except reload current page?

[jrideout]

You can set a filter to null to reset the filter. Or you can call dc.filterAll to reset all filters managed by dc (note if you haven't passed a dimension to a dc chart, this won't reset it).

[zhx828]

@jrideout Thank you. All solved.

[jsmedmar]

@zhx828 could you provide and example on how you achieve this? would be much appreciated.