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
3 replies
Subscribers
5 subscribers
Views
1823 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
How to save (update) fields values to SQL server table from process instance?
amitm
over 10 years ago
How to save (update) fields values to SQL server table from process instance?
When process runs business logic, it is able to fetch old values through CDT. But when CDT getting updated for a process instance, how will it update the new value to sql server database table?...
OriginalPostID-78092
OriginalPostID-78092
Discussion posts and replies are publicly visible
0
Mark Talbot
Appian Employee
over 10 years ago
Hi Amit, can you tell me more about what you are attempting to achieve? Are you looking to persist information to a data store?
forum.appian.com/.../Write_to_Multiple_Data_Store_Entities_Smart_Service
or are you referring to the Process Upgrade API when you say "getting updated for a process instance"?
forum.appian.com/.../Process_Upgrade
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
nareshs
over 10 years ago
Amit, Is your CDT with these annotations?
@Id
@GeneratedValue
If yes, use that retrieved primary key value in same type CDT variable and pass it to “Write to Data Store” along with all updated CDT values, it will take care of Updating automatically.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
amitm
over 10 years ago
Thanks for responses . Now It is working by using 'Multiple Data Store Entities Smart Service'.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel