Server side pagination with Iris?

Question

Question

Blaise ZARKA · Mar 3, 2020

Hi,

Do you have any experience in server side pagination with IRIS using Angular on the client side?
Any idea on a typical SQL request on the server side?

Thanks!
Blaise

Discussion (6)0

Log in or sign up to continue

Vitaliy Serdtsev · Mar 3, 2020

Paginating a Result Set (%vid)
%ScrollableResultSet

1 0

score 0 · Answer 1 · 2020-03-03T04:50:09-05:00

Blaise ZARKA · Mar 3, 2020

thank you Vitaliy.
Perfect.

0 0

score 1 · Answer 2 · 2020-03-03T04:48:12-05:00

Hi Blaise!

Check RESTFORMS2 - it has examples of pagination. And it has an implementation for Angular I believe. Tagging @Henry Pereira , @Eduard Lebedyuk , @Sergey.Sarkisyan , @Alberto Fuentes for more info.

score 1 · Answer 3 · 2020-03-03T04:49:25-05:00

Evgeny Shvarov · Mar 3, 2020

BTW, Restfroms2 can be installed via zpm, e.g.:

zpm:USER>install restforms2

1 0

score 0 · Answer 4 · 2020-03-03T04:51:22-05:00

Blaise ZARKA · Mar 3, 2020

thank you Evgeny!

0 0

score 1 · Answer 5 · 2020-03-03T05:05:39-05:00

You are welcome, Blaise!

RESTFORMS is an amazing tool. You import it, you derive your persistent class from Forms.Adaptor (like here) and you get a working REST API generated automatically.

With pagination.