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
7 subscribers
Views
5838 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Process a field in a Datasubset
Kyle Jorgensen
over 7 years ago
I have a datasubset that I am generating for a download link and I would like to process a couple of the fields in the data to make the download more usable for users. Is there a way to apply a function (such as a function to take a username and render a "Firstname Lastname") to a field in a datasubset while preserving the structure of the datasubset?
OriginalPostID-267809
Discussion posts and replies are publicly visible
0
harrys
over 7 years ago
If you're displaying the datasubset contents of an a!gridField, you can display the contents of the function in the "data" portion of one of the grid's a!gridTextColumn components.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Kyle Jorgensen
over 7 years ago
That won't work since I am using this in a download rather than displaying in a grid. The end result needs to be a datasubset that can be exported.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
harrys
over 7 years ago
Are you getting the datasubset from a database? If so, can you construct a view that concatenates the first and last name?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
aloks0189
Certified Lead Developer
over 7 years ago
@kylej Can you share the Screenshot as well as the code, for this requirement which you are trying to achieve
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Stefan Helzle
A Score Level 3
over 7 years ago
Using the function updatecdt() you can add any field to any data structure. Check
forum.appian.com/.../summary
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
jamalc8231
over 7 years ago
stefanh791 is right. The updatecdt pluggin should work
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Rama Thummala
Certified Lead Developer
over 7 years ago
@kylej
One you get the data from database, create an expression rule that returns dictionary and convert it back to datasubset.
For example , we are getting firstName and lastLast,in expression rule return as below
{
label:"fullName",
value:ri!data.firstName&" "&ri!data.lastName
}
and convert the output of expression rule to datasubset by using todatasubset().
Hope this will help!!!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Kyle Jorgensen
over 7 years ago
@ramanjaneyulut I think that will work; break out the dataset and then processes each field separately before converting it back to a dataset. Since this generally only happens once (when the user clicks the download link) performance shouldn't be too much of an issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel