Pagination can be achieved in many ways - using different data source or algorithm:
1. https://www.outsystems.com/forge/component-overview/12354/paginating-data-action-example-o11
2. https://www.outsystems.com/forge/component-overview/19005/paging-data-action-o11 for Advance query data source
3. this forge
and it is a must have capabilities in real project as raised in a forum:
https://www.outsystems.com/forums/discussion/93834/how-to-do-pagination-when-get-data-from-dataaction/
The concept is that:
1. Find the data in an index range (say from record 5 until record 9 for max record = 5) with data filtering and sort
2. using pagination widget with communicate with the data fetching
3. event: PaginationOnNavigate on Pagination widget, OnSort on the TableRecord, and other event that will reset a parameter, say it StartIndex on Input_SearchKeywordOnChange
4. another bonus is DataAction_GetUsers.IsDataFetched and blanks slate, spinner to window dressing for good user experience (UX)