Hello

For pagination with Advance SQL widget there are multiple post there you can check them here:-

• https://www.outsystems.com/forums/discussion/56770/sql-offset-and-os-pagination/
• https://www.outsystems.com/forums/discussion/56822/reactive-web-application-paginate-a-table-with-an-advancedsql-source/

Hope this helps
Best Regards
Tousif Khan

Hi,

For sorting you can take a look at this:

https://www.outsystems.com/forums/discussion/67915/i-have-problems-with-order-by-in-sql/

I advise you to take a look at this one too because of the warning of Expand Inline necessary to the sorting (the problem is not the warning, is the Expand inline itself):

https://success.outsystems.com/documentation/best_practices/development/building_dynamic_sql_statements_the_right_way/

Hope this can help you.

Best regards,

Ricardo Pereira