• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 8 replies
  • Subscribers 6 subscribers
  • Views 2351 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
    ... l!datasubset.totalCount=0,{""},index(local!datasubset.data, "ApprovalDate", null))
    ),
    a!gridTextColumn(
    label: "Approved By",
    field: "ApprovedBy",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ApprovedBy", null))
    ),
    a!gridImageColumn(
    label: "Request",
    field: "lightRequest",
    size: "ICON",
    data: if(local!datasubset.totalCount=0,null(),apply(a!documentImage, apply(rule!testColor2,if(local!datasubset.totalCount=0,{0},index(local!datasubset.data, "lightRequest", null))),null,null,null))
    ),
    a!gridImageColumn(
    label: "Manager Approval",
    field: "lightManager",
    size: "ICON",
    data: if(local!datasubset.totalCount=0,null(),apply(a!documentImage, apply(rule!testColor2,if(local!datasubset.totalCount=0,{0},index(local!datasubset.data, "lightManager", null))),null,null,null))
    )
    },
    ...
Reply
  • 0
    ... l!datasubset.totalCount=0,{""},index(local!datasubset.data, "ApprovalDate", null))
    ),
    a!gridTextColumn(
    label: "Approved By",
    field: "ApprovedBy",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ApprovedBy", null))
    ),
    a!gridImageColumn(
    label: "Request",
    field: "lightRequest",
    size: "ICON",
    data: if(local!datasubset.totalCount=0,null(),apply(a!documentImage, apply(rule!testColor2,if(local!datasubset.totalCount=0,{0},index(local!datasubset.data, "lightRequest", null))),null,null,null))
    ),
    a!gridImageColumn(
    label: "Manager Approval",
    field: "lightManager",
    size: "ICON",
    data: if(local!datasubset.totalCount=0,null(),apply(a!documentImage, apply(rule!testColor2,if(local!datasubset.totalCount=0,{0},index(local!datasubset.data, "lightManager", null))),null,null,null))
    )
    },
    ...
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.