Hi, I'm hoping someone can point me in the right direction or ha

allenk over 10 years ago

Hi,

I'm hoping someone can point me in the right direction or has some info to share. I'll start by saying that we are new to Appian so if possible please keep any replies as simple as possible.

I have a CDT containing several columns of text type data. I'm trying to slice and dice the CDT into various segments to populate form list boxes, this segment of data is always filtered based on the first two columns.In the drop down list box I would like it to display a concatenation of 2 fields from the CDT (neither of which are the fields being filtered on) though the saved value is just one of those two fields.

I need this to be as re-usable as possible as I need to do this dozens of times for each of my processes

Example:
CDT: ColumnA, ColumnB, ColumnC,ColumnD
List box contents are filtered: ColumnA=Z and ColumnB=Y
List box displays concatenated: ColumnC - ColumnD
The saved value: ColumnC

Thanks for any help you can provide....

Discussion posts and replies are publicly visible

0 Tim
Certified Lead Developer
over 10 years ago

Create an expression called concatStrings that takes 2 strings in as inputs and returns the concatenated value (e.g. ri!string1&" - "&ri!string2).
Then in your display expression use: apply(rule!concatStrings, merge(pv!CDT.ColumnC, pv!CDT.ColumnD)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 allenk over 10 years ago

Hi Tim, thanks for that and I will definitely give it a shot, do you by chance have any suggestions on Filtering the CDT by multiple fields?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 evan.rust
Appian Employee
over 10 years ago

First create a rule (rule!myRule) that takes an "Any Type" input and returns true if the two fields (myCdt.a,myCdt.b) equal the filter criteria (a,b):

and(ri!myCdt.a=ri!a,ri!myCdt.b=ri!b)

Then, you can use this rule with filter() to return only the elements of the CDT that you've filtered for:

filter(rule!myRule,{pv!cdt})
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 evan.rust
Appian Employee
over 10 years ago

You will need to pass your filter criteria into filter() as context per: forum.appian.com/.../Looping_Functions

e.g., filter(rule!myRule,{pv!cdt},"a","b")
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 allenk over 10 years ago

Thanks for the help guys. I appreciate it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel