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



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?