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
10 replies
Subscribers
8 subscribers
Views
10282 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Update single column in a table (Update single field in cdt)
Rama Thummala
Certified Lead Developer
over 7 years ago
Hi,
In Appian normally we will update a record by passing complete record with updated data.
I have a requirement to update single column in a table(updating single field in a record) instead of updating complete record.
like, update <table> <field>=<value> where <key>=<value>.
OriginalPostID-243101
Discussion posts and replies are publicly visible
Parents
0
Jaggu
over 7 years ago
Query Database Approach will be good, but Appian does not suggest that because its not a best practice.
If you configure Query database, after deployment to other environments then you to open the model and reconfigure it again (if data source changes).
You can create a datatype to update that particular field, but if you want to update column 1 in one model and column 2 in 2nd model and so on.
Then you cannot create so many data types for required columns to update.
My suggestion is that use Write to data store entity smart service and pass full CDT.
Because this will not result into any performance issue not manual update when data source changes.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Jaggu
over 7 years ago
Query Database Approach will be good, but Appian does not suggest that because its not a best practice.
If you configure Query database, after deployment to other environments then you to open the model and reconfigure it again (if data source changes).
You can create a datatype to update that particular field, but if you want to update column 1 in one model and column 2 in 2nd model and so on.
Then you cannot create so many data types for required columns to update.
My suggestion is that use Write to data store entity smart service and pass full CDT.
Because this will not result into any performance issue not manual update when data source changes.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data