Hi Everyone,
Is it possible to update the certain columns only and not all columns of a data store entity using write to multiple datastore entity smart service.
Thank you!
Discussion posts and replies are publicly visible
Writing to a datastore will always update the full row. This is in contrast to Appian Records, where only the provided fields will be updated.
, Is there any way so that only required columns are updated in a row, not the full row.
Not with CDTs and Data Stores.
May I ask why you are concerned?
The node is taking much time. We need to reduce the time it takes.
Rahul009 - You can create another CDT with only the required columns you intend to write (steps - download the current CDT XSD, remove the unwanted column definitions, change the name of the CDT and create a new one with this file). Create a data store entity for this CDT.
When you try writing using this new entity, only the required columns of the existing row will be updated.
Note: Use this approach only when it is extremely necessary(when you don't want to bring unwanted columns with huge data into process models).
Please explain exactly what you mean by that? Are you talking about the time it takes to execute the DB update, or about the time it takes for the node to complete?
Thanks Selvekumar, Will the table remain same and only the new CDT to be created?
Yes, the table will remain the same.