SAC - Story - Scripting - Get result set data - dimension members of result set

[axel_]

Hi Folks,

I got a table with an index field. As I want to display the table on a screen with no automatied scrolling/limited space I need to filter 1-25, 26-50, 51-75 ... entries via script and timer.

Is there a way to determine the highest index field number of my table -> read the result set somehow?

Table_1.getDataSource().getResultMember() requires a selection ... which I do not have ...

Thanks for all advice and best regards

Axel

[eeddggaarr]

Hi Axel,

what if you sort your table (or a hidden dummy table) with your index field descending and suppress totals. Then you can use a

console.log(Table_1.getDataSource().getResultSet()[0]);

to get the first row which should include the highest index number?
br
edgar