Paging clauses in Data Provider Group Statement

Official Content
This documentation is valid for:

In order to handle a potentially large number of records, the Count and Skip clauses let you control how many records will go to the Output.

Syntax

<Paging> ::= [ '['Count = <NumericExpression>']' ] [ '['´Skip = <NumericExpression>']´ ]

Examples

The following will skip the first 100 customers and Output the next 20.

Customers 
{
   Customer [Count = 20] [Skip = 100]
   {
      Code = CustomerId
      Name = CustomerName
   }
}

This is the clause used to handle all the paging, for example:

parm(&PageNumber, &PageSize)
Customers 
{ 
   Customer [Count = &PageSize] [Skip = (&PageNumber - 1) * &PageSize] 
   {
     Code = CustomerId
     Name = CustomerName
   }
}

This will handle any number of page lines and any page size.