159064 - no subject - How can I display cdt values in the SAIL

zulfiqarp over 8 years ago

How can I display cdt values in the SAIL report which is querying a record? I am getting blank for Mod ID which is coming from a amendmentRequest_Info cdt. Below is my code:
load(
local!pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: 20,
sort: a!sortInfo(
field: "complianceComment",
ascending: true
)
),
with(
local!datasubset: queryrecord(
cons!PPLM_CUSIP_FEE_RECORD,
a!query(
selection: a!querySelection(columns: {

a!queryColumn(field: "amendmentRequest_Info.amendmentRequestID"),
a!queryColumn(field: "complianceComment"),
}),
pagingInfo: local!pagingInfo
)
),
a!gridField(
totalCount: local!datasubset.totalCount,
columns: {

a!gridTextColumn(
label: "Mod ID",
field: "amendmentRequest_Info.amendmentRequestID",
data: index(local!datasubset.data, "amendmentRequest_Info.amendmentRequestID", nu...

Discussion posts and replies are publicly visible

Parents

0 Mike Schmitt
Certified Lead Developer
over 8 years ago

As far as I know you should be able to access the multiple property just fine; but unless you do some sort of text formatting it'll probably just cast itself to a flat semicolon-separated string.

Also if I can suggest an unrelated tweak, you should replace your "null" calls with "{}" (empty set), which is handled better by the gridField when no data is returned.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Mike Schmitt
Certified Lead Developer
over 8 years ago

As far as I know you should be able to access the multiple property just fine; but unless you do some sort of text formatting it'll probably just cast itself to a flat semicolon-separated string.

Also if I can suggest an unrelated tweak, you should replace your "null" calls with "{}" (empty set), which is handled better by the gridField when no data is returned.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data