• State Not Answered
  • Replies 9 replies
  • Subscribers 5 subscribers
  • Views 6798 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

handling query entity errors

erickp
I have a query entity rule that is pulling data from a view. Sometimes it throws the famous error: An error occurred while retrieving the data. (APNX-1-4198-000) which means the view timed out. Is there any way to handle this error to display a more friendly message to the user? Such as: Please add some more filters to the search.

OriginalPostID-247425

  Discussion posts and replies are publicly visible

Parents
  • 0
    @scottf281: 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.
Reply
  • 0
    @scottf281: 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.
Children
No Data

© 2024 Appian. All rights reserved.