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

zulfiqarp over 9 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 sikhivahans over 9 years ago

@zulfiqarp I understood the scenario after your further clarification. Where do you want to surface the report(Is it in Reports tab?) and does the report gather data from all the processes(where each process in-turn having process variable of type multiple cdt)? Answer to these questions will unfold the way you need to opt for getting the job done.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 9 years ago

@zulfiqarp I understood the scenario after your further clarification. Where do you want to surface the report(Is it in Reports tab?) and does the report gather data from all the processes(where each process in-turn having process variable of type multiple cdt)? Answer to these questions will unfold the way you need to opt for getting the job done.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data