• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 8 replies
  • Subscribers 5 subscribers
  • Views 2536 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

Problem with a sail report

marcoc200

Hello,
I have a problem with a sail report. This is my sail code
=load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 20,
sort: a!sortInfo(
field: "buttonDelete",
ascending: true
)
),
a!dashboardLayout(
firstColumnContents: {
a!sectionLayout(
label: "Close Request",
firstColumnContents: {
with(
local!datasubset: queryrecord(
cons!ApacRequestMobileReport,
a!query(
selection: a!querySelection(columns: {
a!queryColumn(field: "ApacRequestMobile.ID", alias: "ID"),
a!queryColumn(field: "ApacRequestMobile.Name", alias: "Requestor"),
a!queryColumn(field: "ApacRequestMobile.LeaveCode", alias: "LeaveType"),
a!queryColumn(field: "ApacRequestMobile.ApplyDate", alias: "ApplyDate"),
a!queryColumn(field: "ApacRequestMobile.FromDate", alias: "FromDate"),
a!queryColumn(field: "ApacRequestMobile.FromTime", alias: "...

OriginalPostID-134572

OriginalPostID-134572

  Discussion posts and replies are publicly visible

Parents
  • 0
    ... value: local!pagingInfo,
    saveInto: local!pagingInfo
    )
    )
    }
    )
    }
    )
    )

    if the begging i change the filter filter: a!queryFilter(field: "lightManager", operator: "<", value: 2) with the filter filter: a!queryFilter(field: "lightManager", operator: ">=", value: 2) the report doesn't work and this is the error message "Interface Definition: Expression evaluation error at function a!dashboardLayout [line 10]: A grid component [label=“”] has an invalid value for “totalCount”. “totalCount” must not be null or less than the number of items in any of the “data” arrays, but “totalCount” was 0 and the largest column data array had 1 items."

    someone can help me please
Reply
  • 0
    ... value: local!pagingInfo,
    saveInto: local!pagingInfo
    )
    )
    }
    )
    }
    )
    )

    if the begging i change the filter filter: a!queryFilter(field: "lightManager", operator: "<", value: 2) with the filter filter: a!queryFilter(field: "lightManager", operator: ">=", value: 2) the report doesn't work and this is the error message "Interface Definition: Expression evaluation error at function a!dashboardLayout [line 10]: A grid component [label=“”] has an invalid value for “totalCount”. “totalCount” must not be null or less than the number of items in any of the “data” arrays, but “totalCount” was 0 and the largest column data array had 1 items."

    someone can help me please
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.