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

Discussion posts and replies are publicly visible

Parents

0 saicharanb over 7 years ago

@sikhivahans: I am using page grid not SAIL form. May be that's the reason batch size is not dynamically updated. Is there any way to dynamically update pagingInfo with the next batch size? For example: I have 30 records to fetch, batch size is 20, only 20 records appear in the results. Other 10 records 21-30 are not fetched. Can we update the batch size once initial set of records are retrieved?

=rule!WFT_tempoSearchQueryPagination(pv!process,pv!subprocess,pv!action,pv!requestorName,pv!company,pv!reference,pv!sapRefNo,pv!fromDate,pv!toDate,pv!monetaryValue,pv!priority,pv!wftRequestID,pv!salesOffice,pv!requestStatus,data!pagingInfo)

data!pagingInfo can solve my problem? I read that pagingInfo is based on the rows per page in Page Grid. If I reduce "rows per page" and use pagingInfo in query rule.
Thanks in advance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 saicharanb over 7 years ago

@sikhivahans: I am using page grid not SAIL form. May be that's the reason batch size is not dynamically updated. Is there any way to dynamically update pagingInfo with the next batch size? For example: I have 30 records to fetch, batch size is 20, only 20 records appear in the results. Other 10 records 21-30 are not fetched. Can we update the batch size once initial set of records are retrieved?

=rule!WFT_tempoSearchQueryPagination(pv!process,pv!subprocess,pv!action,pv!requestorName,pv!company,pv!reference,pv!sapRefNo,pv!fromDate,pv!toDate,pv!monetaryValue,pv!priority,pv!wftRequestID,pv!salesOffice,pv!requestStatus,data!pagingInfo)

data!pagingInfo can solve my problem? I read that pagingInfo is based on the rows per page in Page Grid. If I reduce "rows per page" and use pagingInfo in query rule.
Thanks in advance.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data