Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
29 replies
Subscribers
7 subscribers
Views
6110 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Pagination - Memory threshold issue.
saicharanb
over 7 years ago
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
0
saicharanb
over 7 years ago
I have a query rule : =rule!Pagination(pv!wftRequestID,pv!salesOffice,pv!requestStatus,a!pagingInfo(startIndex: 1,batchSize: 100),loggedinuser()) which is returning me 100 records. Now after this, I need to retrieve records 201 to 300. Do I need to implement another rule with =rule!Pagination(pv!wftRequestID,pv!salesOffice,pv!requestStatus,a!pagingInfo(startIndex: 101,batchSize: 200),loggedinuser()) ? If so how do I integrate these two rules ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
saicharanb
over 7 years ago
I have a query rule : =rule!Pagination(pv!wftRequestID,pv!salesOffice,pv!requestStatus,a!pagingInfo(startIndex: 1,batchSize: 100),loggedinuser()) which is returning me 100 records. Now after this, I need to retrieve records 201 to 300. Do I need to implement another rule with =rule!Pagination(pv!wftRequestID,pv!salesOffice,pv!requestStatus,a!pagingInfo(startIndex: 101,batchSize: 200),loggedinuser()) ? If so how do I integrate these two rules ?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data