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.

 





 




Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.