Leverage sql syntax OFFSET and fetch for pagination using Data Action.
The pagination become simple and easy to maintain.
Syntax Core:
"SELECT *
FROM {TechLead} TechLead
where TechLead.[Description] like '%"+DescriptionSearch+"%' order by " + EncodeSql(TableSort) +
" OFFSET " +StartIndex+" rows " +
" fetch next " + MaxRecords + " rows only "