I used advanced sql to group my table based on email.and now i want to use the sql output list in Outsystems table.im unable to get the total count (same as like aggregates) for the pagination.how to make pagination work on advance sql.I have attached my structure and sql query
Hi @Joe AJ ,
Please check the below article for pagination.
https://www.outsystems.com/forums/discussion/83660/pagination-and-sorting-using-advanced-sql-in-reactive/
https://www.outsystems.com/forums/discussion/56822/reactive-web-application-paginate-a-table-with-an-advancedsql-source/#
https://www.outsystems.com/forums/discussion/56770/sql-offset-and-os-pagination/#
Hope this helps,
Regards,
Manish Jawla