AnsweredAssumed Answered

Access to table component's record set from button click

Question asked by Glupe Registracije on Sep 28, 2018
Latest reply on Sep 28, 2018 by Glupe Registracije

Hi,

 

if I have a table component with underlying data source, how can I access datasource records from button click JavaScript ?

 

Let's say that I have a huge clickhouse (database) table (with billions of records). I have a datasource that extracts 50 records from that table, that will be shown in pentaho table component.

Now on button click, I would like to calculate some statistics for these 50 records, but I would like to avoid using new sql queries in order to speed up loading pentaho page.

What I need is access to these 50 records, so I can loop through them, find minimum, maximum, count of certain type of records and so on.

How to access table component record set from button click?

 

Regards.

Outcomes