Pagination - Memory threshold issue.

We have a query as below
rule!WFT_getRequestDetailsBySearchParams(ri!process,ri!subprocess,ri!action,ri!requestor,ri!company,ri!reference,ri!sapRefNo,if(isnull(ri!fromDate),todatetime(date(2010,10,10)),ri!fromDate),if(isnull(ri!toDate),todatetime((today())),ri!toDate+intervalds(23,59,59)),ri!monetaryValue,ri!priority,ri!wftRequestID,ri!salesOffice,ri!requestStatus,ri!pageInfo)))

In the above query how is "ri!pageInfo" working? I could not find any parameters like batch size set for pageInfo. Please help how does it work for the above query.

How does pageInfo decrease the load on Appian? I have referred the below link, but did not understand much, Please help me on this.
forum.appian.com/.../System_Functions.html

OriginalPostID-254399

  Discussion posts and replies are publicly visible

Parents
  • Yes when you specify the batchsize it will only return that many records, You have 20 records and you specified with batchsize as 10 only 10 records displayed. if you have total 9 records when you specify the batchsize as 10 then it will display 9 records only. when you specify the batchsize as -1 it will display all of the records.
Reply
  • Yes when you specify the batchsize it will only return that many records, You have 20 records and you specified with batchsize as 10 only 10 records displayed. if you have total 9 records when you specify the batchsize as 10 then it will display 9 records only. when you specify the batchsize as -1 it will display all of the records.
Children
No Data