The other day I was working on a project and needed to fetch a specific set of rows from a custom SQL in OutSystems. In normal OutSystems lingo we call this “paginating.” That’s when I remembered the handy OFFSET <n> ROWS and FETCH NEXT <n> ROWS ONLY clauses. These are perfect for paginating through data.
Read more: https://medium.com/@erwinvanrijsewijk/paginating-in-outsystem-custom-sql-0caffc406b3a