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

0 sikhivahans over 9 years ago

@zulfiqarp I would like to ask you one question - Do you want to display the parent and child in the same report i.e. one row containing details of top level CDT along with the details of nested multiple CDTs?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zulfiqarp over 9 years ago

@sikhivahans I do not want to display parent and child in the same report. My challenge is displaying a cdt with multiple values in a grid from a process based record in a SAIL report. Please let me know if you need more clarification. I apologize for confusion.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

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

@sikihivahans I want to surface the report on Report (SAIL). Also, I want to gather data from all the processes. Currently, I am using a process back record as a source to gather data from all the process.
Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@zulfiqarp Please find attached the document and do let me know if you have any followup questions.
Approach.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 zulfiqarp over 9 years ago

@sikhivahans I am going with second approach. Thank you for your detail solution.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 9 years ago

@zulfiqarp My pleasure, please do let me know if you have any problems while transforming pseudocode into actual Appian objects.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel