Problem with a sail report

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
  • ... if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "FromTime", null))
    ),
    a!gridTextColumn(
    label: "To Date",
    field: "ToDate",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ToDate", null))
    ),
    a!gridTextColumn(
    label: "To Time",
    field: "ToTime",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ToTime", null))
    ),
    a!gridTextColumn(
    label: "Reason",
    field: "Reason",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "Reason", null))
    ),
    a!gridTextColumn(
    label: "Status",
    field: "Status",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "Status", null))
    ),
    a!gridTextColumn(
    label: "Approval Date",
    field: "ApprovalDate",
    data: if(loca...
Reply
  • ... if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "FromTime", null))
    ),
    a!gridTextColumn(
    label: "To Date",
    field: "ToDate",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ToDate", null))
    ),
    a!gridTextColumn(
    label: "To Time",
    field: "ToTime",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "ToTime", null))
    ),
    a!gridTextColumn(
    label: "Reason",
    field: "Reason",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "Reason", null))
    ),
    a!gridTextColumn(
    label: "Status",
    field: "Status",
    data: if(local!datasubset.totalCount=0,{""},index(local!datasubset.data, "Status", null))
    ),
    a!gridTextColumn(
    label: "Approval Date",
    field: "ApprovalDate",
    data: if(loca...
Children
No Data