Paging In Service Backed Record

Question

Hi All, 
 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

Vinay Kumar Rai · Answer

HI, 
 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 
 <Select Statement> 
 OFFSET (@StartIndex -1) ROWS FETCH NEXT @BatchSize ROWS ONLY 
 
 after select, if you are using SQL Server