TableReport client widget

Clarke

01 multi-sort massive tablereport.PNG

02 export button.PNG

03 sooo close but sooo far.PNG

Hello Smart UI Community,

I am working on a Custom Report that returns a massive number of rows (>100,000)

I am displaying the report to the Smart UI with the TableReport widget.

(Finally) I have TableReport widget working with multiple sortable columns, including dates.

The table works great.

On the page, I want to provide an export button, so that the report can be exported to CSV via a WR.

I'm only working in WRs, no Custom Smart UI module.

To get the button on the page, I initiate the Table Report myself via the HTML WR Widget, and I also add an export button.

The problem I have if I can't get the filter values from the TableReport widget.

How can I ask the widget what values of the filter?

When I click about I can see the Table Widget sending them back to OTCS.

I doubt I can access them on the Server side, but if I could ask the Widget on the Client in JS, then my button could use the same query/Livereport to export/when my button is clicked.

How can I export the TableReport client widget with the Current Filter?

Or what is the best way to export the results from TableReport?

Regards,

-MC

Clarke

Update, I was able to access the filters inside the tableReportView by making it Global.

Once it is global, I can peak inside and get the current filter. Now I can collect in the params and call another WR to perform the CSV export.

To bad the Table Report Widget doesn't have the CSV export built in....

  alert(tableReportView.columns.options.orderBy);

If there is a better way to do this I'm open to alternatives.

Regards,

-MC