696
Views
6
Comments
Solved
Advanced SQL and pagination
Question

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.

Rank: #107

Hi !

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

mvp_badge
MVP
Rank: #14

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

Rank: #107

Thank you

Rank: #662

I will share how I usually do, can help someone.