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
Parents
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
Reply
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
Children
No Data