• State Not Answered
  • Replies 9 replies
  • Subscribers 4 subscribers
  • Views 2829 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Reports

The 7.9 SAIL Receipe: Display Data with CDT Fields from a Record in a Grid

greggl

The 7.9 SAIL Receipe: Display Data with CDT Fields from a Record in a Grid
forum.appian.com/.../SAIL_Recipes.html

says "Let's use the process-backed record from the Records Tutorial. ", but the Records Tutorial doesn't use a CDT.

And the resulting SAIL Code below doesn't work when I adapt to a Record using a CDT.

How do you adapt this approach, for that matter anything produced by the Report Builder to a CDT?

Thanks,
Gregg


load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 20,
sort: a!sortInfo(
field: "expenseItem",
ascending: true
)
),
with(
local!datasubset: queryrecord(
cons!EXPENSE_REPORT_RECORD,
a!query(
selection: a!querySelection(columns: {
a!queryColumn(field: "expenseItem"),
a!queryColumn(field: "expenseAmount"),
a!queryColumn(field: "pp.initiator", alias: "initiator")
...

OriginalPostID-152536

  Discussion posts and replies are publicly visible

Parents
  • 0
    ... }),
    pagingInfo: local!pagingInfo
    )
    ),
    a!gridField(
    totalCount: local!datasubset.totalCount,
    columns: {
    a!gridTextColumn(
    label: "Item",
    field: "expenseItem",
    data: index(local!datasubset.data, "expenseItem", null)
    ),
    a!gridTextColumn(
    label: "Amount",
    field: "expenseAmount",
    data: index(local!datasubset.data, "expenseAmount", null)
    ),
    a!gridTextColumn(
    label: "Requested By",
    field: "initiator",
    data: index(local!datasubset.data, "initiator", null)
    )
    },
    value: local!pagingInfo,
    saveInto: local!pagingInfo
    )
    )
    )

Reply
  • 0
    ... }),
    pagingInfo: local!pagingInfo
    )
    ),
    a!gridField(
    totalCount: local!datasubset.totalCount,
    columns: {
    a!gridTextColumn(
    label: "Item",
    field: "expenseItem",
    data: index(local!datasubset.data, "expenseItem", null)
    ),
    a!gridTextColumn(
    label: "Amount",
    field: "expenseAmount",
    data: index(local!datasubset.data, "expenseAmount", null)
    ),
    a!gridTextColumn(
    label: "Requested By",
    field: "initiator",
    data: index(local!datasubset.data, "initiator", null)
    )
    },
    value: local!pagingInfo,
    saveInto: local!pagingInfo
    )
    )
    )

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