Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
Replies
4 replies
Answers
1 answer
Subscribers
5 subscribers
Views
4479 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
Is there a way to modify a particular row of a CDT? USE CASE: I have a CDT
yagyadeepk
over 9 years ago
Is there a way to modify a particular row of a CDT?
USE CASE: I have a CDT(multiple type) having 4 columns say A,B,C,D and i have 4 rows of data in it. I want to modify the C column value of the 3rd row to some value x. How to achieve this in the data output tab of a node?
I have achieved this quite easily using SAIL code. Any suggestions on how to achieve this while process modelling? ...
OriginalPostID-134575
OriginalPostID-134575
Discussion posts and replies are publicly visible
Parents
0
radhaa
over 9 years ago
Hi yagyadeep, we have multiple ways to do this, you can update/modify the DB data using write to data store entity smart service node.
For example:
In Script Task Data Inputs,retrieve data from DB by primary key of that 3rd row and store it in respective CDT Type acp parameter (say cdt_sample).
Data outputs,
1. Store that acp Parameter in pv value
2. the modified value placed in Custom output expression and stored as cdt_sample.c
Go through this link
forum.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html
you can get better idea.
It may help to you
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
radhaa
over 9 years ago
Hi yagyadeep, we have multiple ways to do this, you can update/modify the DB data using write to data store entity smart service node.
For example:
In Script Task Data Inputs,retrieve data from DB by primary key of that 3rd row and store it in respective CDT Type acp parameter (say cdt_sample).
Data outputs,
1. Store that acp Parameter in pv value
2. the modified value placed in Custom output expression and stored as cdt_sample.c
Go through this link
forum.appian.com/.../Write_to_Data_Store_Entity_Smart_Service.html
you can get better idea.
It may help to you
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data