In a SQL ADVANCE, you need use (example with 10):

• SQL 
  • SELECT TOP 10 .... .... 
• Oracle

  • ... ... WHERE ROWNUM <= 10

In a Aggregate:

• The attribute for max. records in the aggregate can be filled with an variable
  • 
  • Note: you can use a variable, like maxrec, or can put directly a integer number. It's a optional field.

Cheers

Hi Rodrigo,

you can try this on advanced  query.

SELECT {JulyReport}.[Id],{JulyReport}.[SELB],{JulyReport}.[Equipamento] from {JulyReport}
order by {JulyReport}.[Id],{JulyReport}.[SELB],{JulyReport}.[Equipamento] asc
OFFSET @StartIndex ROWS 
FETCH NEXT @RowCount ROWS ONLY

Hope this will help you.

Vijay M-

Hi Rodrigo,

Refer the below forum link and the screen clip for sample implementation reference

https://www.outsystems.com/forums/discussion/56770/sql-offset-and-os-pagination/#Post214278

Hope this helps you!

Regards,

Benjith Sam