Hello Ravichand G Y,

Are you using an Advance SQL Querry or an Arrgagate? 

Best regards 

Paulo Rosário

You will find all the documentation needed on this link to show you the necessary steps to accomplish server-side pagination with Data Grid.

Hope it helps! 

Paulo Rosário 

To manage server-side pagination effectively, you can utilize Advanced SQL Queries. Here's how you can do it:

1. Create a Server or Service Action with two input parameters and two outputs:
   • StartIndex (Integer) Input
   • MaxRecords (Integer) Input 
   • TotalCount (Long Integer) Output

   •  YourStructure (List) Output 

     
     

2. Example Query:
   SELECT {EntityName}.*FROM {EntityName}
   WHERE ({EntityName}.[Attribute] = 1)
   ORDER BY {EntityName}.[Attribute] ASC
   OFFSET @StartIndex ROWS
   FETCH NEXT @MaxRecords ROWS ONLY
   
   
   
3. Utilize this action in the pagination UI component provided by OutSystems.
4. Handle the UI functionality:
   • Initially set StartIndex = 0 and MaxRecord = 10.
   • When the user clicks "Next", update StartIndex as StartIndex = MaxRecord + 1.

This setup enables efficient handling of server-side pagination, ensuring smoother navigation through large datasets.