• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 8 replies
  • Subscribers 5 subscribers
  • Views 2533 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
    ... data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ID", null))
    ),
    a!gridTextColumn(
    label: "Requestor",
    field: "Requestor",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "Requestor", null))
    ),
    a!gridTextColumn(
    label: "Leave Type",
    field: "LeaveType",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "LeaveType", null))
    ),
    a!gridTextColumn(
    label: "Apply Date",
    field: "ApplyDate",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ApplyDate", null))
    ),
    a!gridTextColumn(
    label: "From Date",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "FromDate", null))
    ),
    a!gridTextColumn(
    label: "From Time",
    field: "FromTime",
    data: ...
Reply
  • 0
    ... data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ID", null))
    ),
    a!gridTextColumn(
    label: "Requestor",
    field: "Requestor",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "Requestor", null))
    ),
    a!gridTextColumn(
    label: "Leave Type",
    field: "LeaveType",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "LeaveType", null))
    ),
    a!gridTextColumn(
    label: "Apply Date",
    field: "ApplyDate",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ApplyDate", null))
    ),
    a!gridTextColumn(
    label: "From Date",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "FromDate", null))
    ),
    a!gridTextColumn(
    label: "From Time",
    field: "FromTime",
    data: ...
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.