• State Verified Answer
  • Replies 5 replies
  • Subscribers 6 subscribers
  • Views 3367 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Paging not working

ireneb

Hi

This is probably a stupid question, but I have created a Process Report and a Tempo Report from this.  Unfortunately, I cannot page the grid that results.  Can someone suggest what I am doing wrong?

Code below:

a!localVariables(
  local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: -1,
    sort: a!sortInfo(field: "c3", ascending: true())
  ),
  local!refreshCounter: 0,
  local!datasubset: a!refreshVariable(
    refreshOnVarChange: { local!refreshCounter },
    value: a!queryProcessAnalytics(report: cons!CMN_ALL_TASK_REPORT)
  ),
  a!sectionLayout(
    label: "",
    contents: {
      a!gridField(
        label: "",
        labelPosition: "COLLAPSED",
        data: local!datasubset,
        columns: {
          a!gridColumn(
            label: "Task Name",
            value: a!richTextDisplayField(
              value: {
                a!richTextItem(
                  text: {
                    fv!row.c5,
                    "  ",
                    a!richTextIcon(
                      icon: "external-link",
                      caption: "(Opens in New Window)",
                      size: "MEDIUM"
                    )
                  },
                  link: a!safeLink(
                    uri: rule!CMN_getTaskUrlByTaskId(taskId: fv!identifier)
                  ),
                  linkStyle: "STANDALONE"
                )
              }
            )
          ),
          a!gridColumn(
            label: "Status",
            value: a!richTextDisplayField(
              value: {
                a!richTextItem(
                  text: if(
                    fv!row.c1 = 0,
                    "Assigned",
                    if(
                      fv!row.c1 = 1,
                      "Accepted",
                      if(
                        fv!row.c1 = 5,
                        "Paused",
                        if(
                          fv!row.c1 = 8,
                          "Error",
                          "Unknown (code " & fv!row.c1 & ")"
                        )
                      )
                    )
                  )
                )
              }
            )
          ),
          a!gridColumn(
            label: "Assignee",
            value: a!richTextDisplayField(
              value: a!richTextItem(
                text: {
                  if(
                    find("Group:", fv!row.c4) <> 0,
                    a!richTextIcon(icon: "group"),
                    a!richTextImage(image: a!userImage(user: fv!row.c4))
                  ),
                  " ",
                  rule!APN_displayGroupOrUsername(groupOrUser: fv!row.c4)
                }
              )
            )
          ),
          a!gridColumn(
            label: "Assigned",
            sortField: "c3",
            value: a!richTextDisplayField(value: fv!row.c3)
          ),
          a!gridColumn(
            label: "Process Instance",
            value: a!richTextDisplayField(value: fv!row.c2)
          )
        },
        pagingSaveInto: local!pagingInfo
      )
    }
  )
)

Thanks

Irene

  Discussion posts and replies are publicly visible

  • 0

    Your local!pagingInfo is retrieving the entire list (-1 batch size). You would probably want to set a fixed size there, the number of rows you want to show at a time.

    Then in your a!queryProcessAnalytics, you should use the query parameter and specify the pagingInfo from there.

  • 0 in reply to jraaquino

    Thanks for the quick response.  Unfortunately, if I use the query parameter in the a!queryProcessAnalytics it just returns an error.  I also note in the Help documentation that a!queryProcessAnalytics only appears to return the first page:

    Would you know if this is why this is happening and if so, what I should be using the return all data?

  • 0 in reply to ireneb

    We should not get an error while using a query parameter. your code below with little change as highlighted worked fine.

    Hi Irene,

    your code worked fine with little changes as highlighted.

    a!localVariables(
    local!pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: 10,
    sort: a!sortInfo(field: "c3", ascending: true())
    ),
    local!refreshCounter: 0,
    local!datasubset: a!refreshVariable(
    refreshOnVarChange: { local!refreshCounter },
    value: a!queryProcessAnalytics(
    report: cons!TEST_PROCESS_REPORT,
    query: a!query(pagingInfo: local!pagingInfo)
    )
    ),
    a!sectionLayout(
    label: "",
    contents: {
    a!gridField(
    label: "",
    labelPosition: "COLLAPSED",
    data: local!datasubset,
    columns: {
    a!gridColumn(
    label: "Status",
    value: a!richTextDisplayField(
    value: {
    a!richTextItem(
    text: if(
    fv!row.c1 = 0,
    "Assigned",
    if(
    fv!row.c1 = 1,
    "Accepted",
    if(
    fv!row.c1 = 5,
    "Paused",
    if(
    fv!row.c1 = 8,
    "Error",
    "Unknown (code " & fv!row.c1 & ")"
    )
    )
    )
    )
    )
    }
    )
    ),
    a!gridColumn(
    label: "Assigned",
    sortField: "c3",
    value: a!richTextDisplayField(value: fv!row.c3)
    ),
    a!gridColumn(
    label: "Process Instance",
    value: a!richTextDisplayField(value: fv!row.c2)
    )
    },
    pagingSaveInto: local!pagingInfo
    )
    }
    )
    )

  • 0 in reply to rickyc0004

    Thanks for that.  So, I have changed the code so I no longer receive an error, but it is still not paging past the first page.  Displays a count at the bottom of the page:

    but does nothing when click on the >.

  • +1 in reply to ireneb

    Only just noticed that I had the pagingSaveInto set differently.  I have set this back to local!pagingInfo and all works now.  Thanks for your help.

© 2024 Appian. All rights reserved.