We are using store procedure in the service backed record. We want to add the paging in that.
In the documentation It is given to add paging in integration call but as we are using the store procedure how to add paging.
Thanks In advance
You need to create two new parameters on SP, 1) @StartIndex 2) BatchSize
pass the value on StartIndex : local!PagingIndo.StartIndex
In the SP, You can use
OFFSET (@StartIndex -1) ROWS FETCH NEXT @BatchSize ROWS ONLY
after select, if you are using SQL Server
Discussion posts and replies are publicly visible
© 2020 Appian. All rights reserved.