Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
17 replies
Subscribers
4 subscribers
Views
4755 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
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...
OriginalPostID-159064
Discussion posts and replies are publicly visible
Parents
0
zulfiqarp
over 9 years ago
Thank you sikhivahs! The code that you provided only address one field. How can I display a cdt (multiple) on a report? For example, lets say I have cdt of multiple type dept in my process. Below is the data in the cdt. How do I display cdt value (multiple records) in my report?
Dept ID Dept Name
AB0001 Accounting
AB0002 Finance
AB0003 Marketing
....
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
zulfiqarp
over 9 years ago
Thank you sikhivahs! The code that you provided only address one field. How can I display a cdt (multiple) on a report? For example, lets say I have cdt of multiple type dept in my process. Below is the data in the cdt. How do I display cdt value (multiple records) in my report?
Dept ID Dept Name
AB0001 Accounting
AB0002 Finance
AB0003 Marketing
....
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data