table navigate event

[Former Member]

Hi,

My client wants to display a table with 50.000 records.

Do you know if there is a way to reimplement onnavigate function, in order to do another call to the db like select where ronnum<100 minus rownum<200 ??

Florin

[former_member182372 · Accepted solution]

Hello Florin,

It is not possible to load data to table UI element on-the-fly, but you can emulate such behavior:

1) Create a table. Set property "footerVisible" to false, set visibleRowCount to count of records you would like to see in a table.

2) Add navigation tables "<<", "<", ">", ">>" and textview with number of page.

3) In a context create couple of attributes - rowCount, currentPage and set them to appropriate values (total number of rows, currentpage set initialy to 0).

4) create value node dataSource with appropriate attributes.

5) Inplement data loading using currentpage and count of records you would like to see in a table to dataSource node.

6) set dataSource node as datasource of table.

7) introduce "enable" calculated attribute for every navigation button (to make buttons disabled for border cases) and bind them to enable property of buttons.

😎 implement appropriate button actions for navigation buttons (change currentPage attribute) and reload data using new value in dataSource node.

Best regards, Maksim Rashchynski.