2022-07-07 18-45-50
Niels Favreau
1962Views
8Comments
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.

0
0
07 Jun 2018

Hi !

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

1
0
07 Jun 2018
2016-04-21 20-09-55
J.
 
MVP

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

0
0
07 Jun 2018

Thank you

0
0
07 Jun 2018

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

15
0
11 Dec 2020

Thanks @David Marques  it works for me ;)

0
0
14 Dec 2020

Thanks @David Marques I come from the future 2022 this is still saving lives;)

6
0
17 Mar 2022

Thanks @David Marques I come from the future 2023 this is still saving lives;)

0
0
28 Aug
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.