Dynamics 365财务和运营 在Query 中进行分页X ++ / Paging in Query X++ Dynamics 365 for finance and operations

For paging in X++ Query. There are three steps required. Rest of Query Code is same.

We have to set following things in Query data source

• Set Sort field in Query data Source.
• Paging position property of QueryRun is set to true.
• Add page range with starting position and number of records in QueryRun

Here is code snippet

  QueryBuildRange qbr,qbrStartDate,qbrEndDate; QueryBuildDataSource qbd; IAPageSize EnumPageSize; QueryRun        qr; Query           query = new Query(); Int pageSize = 2;   qbd = query.addDataSource(TableNum(ProjPlanVersion)); qbd.addOrderByField(fieldNum(ProjPlanVersion,HierarchyId)); qr = new QueryRun(query); qr.enablePositionPaging(true);             CurrentPageNumber =1;             startingposition = CurrentPageNumber * pagesize;             qr.addPageRange(startingposition, totalRows); while(qr.next())   {   Info (“”); }