Advanced SQL and pagination

Advanced SQL and pagination

  

Hello,

Does anyone know how to do pagination on a Advanced SQL which is used as source of record list widget?

Can't find anything :/

Greetings,
Niels F.

Hi !

Thank you, but this is based of a forge component :/
Or is it the same logic I have to apply?

almost, you do have to use TOP when in sqlserver etc.


It also depends on how large the return set will be...

if it's already small, you might be better with filtering it afterwards

Thank you