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
8 replies
Subscribers
5 subscribers
Views
2087 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
68879 - no subject - Hi,\nI have a multiple CDT with four fie
saram
over 11 years ago
Hi,
I have a multiple CDT with four fields. I would like to show, in a new Tempo record, a grid with four columns (one for each field) - like the function "ncolumntable" in dashboards.
I tried to put each CDT field (ex. rf!Employees.name) into a "data" field in the Grid Component but it doesn't work.
Thanks!...
OriginalPostID-68879
Discussion posts and replies are publicly visible
0
revat.anandsongkit
Appian Employee
over 11 years ago
Are you using the Common Objects rules?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saram
over 11 years ago
Yes, and also the Grid Documentation (
forum.appian.com/.../Grid_Tutorial):
my case is equal to the one presented in "Create a Basic Grid" but I would like "data" to be my CDT fields and not prefixed values. But, by using the CDT field (as rf!employees.name), it doesn't work. Thanks!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
revat.anandsongkit
Appian Employee
over 11 years ago
What I would recommend trying is saving the CDT as a data subset local variable then referencing that local variable in the fields. In doing so, you are enabling sorting. For example, load(pagingInfo: topaginginfo(1,-1), dataSubset: todatasubset(rf!Employees, pagingInfo), rule!APN_uiPagingGrid(columns:{rule!APN_uiGridTextColumn(label: "Name", field: "name", data: dataSubset.data.name)...})) For more details about datasubet, have a look at
forum.appian.com/.../Appian_Scripting_Functions
and to learn more about paging configuration, have a look
forum.appian.com/.../Paging_Grid_Component
. Hope this helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saram
over 11 years ago
I followed your suggestion and it gives me this error: "Expression evaluation error in rule 'apn_uipaginggrid': Cannot create save from Any Type". Is it sure grid works for multiple CDT in a process? Thanks again.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
revat.anandsongkit
Appian Employee
over 11 years ago
The example I gave was only the first part of the rule...Note that there are 5 parameters for the rule!APN_uiPagingGrid(). 1) label (optional) 2) instructions (optional) 3) columns (required) 4) pagingInfo (required) and 5) totalCount. (required). Remember that we already defined our pagingInfo as a local variable, pagingInfo. As for the total count, we have our data subset, 'dataSubset' and you can use dot notation, dataSubset.totalCount to determine the total count of your data.
I would recommend reading the description on the APN_uiPagingGrid(). Hope this helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
elizabeth.epstein
over 11 years ago
Sara - if you are looking to build a simple grid and don't care about sorting/paging then the tutorial example will work for you. I believe your problem is that you are using values from a multiple CDT directly, which doesn't work in SAIL UI components. Try saving your CDT locally and referencing the fields from there:
with(
employeeData=rf!employees,
type!Grid(
[Your grid code, referencing employeeData.names, employeeData.xxx]
)
)
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saram
over 11 years ago
Thanks to both of you!
Elizabeth, I used your method (only mistake "employeeData:rf!employees" and not equal sign) and it works.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
saram
over 11 years ago
Hi, can I ask you one more question? I have a main process which, at each execution, generates as many subprocesses as the values of a multiple pv!.
In "old" Portal dashboards, I prepared one channel for main process data and a report which had as many dynamic rows as the subprocesses - with a column displaying a link to the dashboard of the subprocess (to see further subprocess-related details).
Now in Tempo, I would like to replicate the same situation: is there a method to see, in the main process record, only process-related subprocesses and have a link to their records (details)? or, can you suggest other solutions?
Thanks in advance again!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel