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
5 replies
Subscribers
6 subscribers
Views
2007 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
I'm starting to build a small process to update some CDT items in a data sto
Richard
over 9 years ago
I'm starting to build a small process to update some CDT items in a data store. The process gathers the records the user cares about using a queryrecord and the result is stored into two arrays (e.g. Array1, Array2). Then I generate a user input task that presents the user with a SAIL form containing a grid whose rows consist of the components I wish them to be able to edit. They can remove rows or add new items to the grid.
When they're finished, I'd like to do a Write to Data Store for the inserts/updates, and a Delete from Data Store. for any existing records they've removed.
My question is, given that I've kept an array of what the original query returned, and I have an array of the user's changes, is there an easy way to determine the deleted items?
OriginalPostID-154279
OriginalPostID-154279
Discussion posts and replies are publicly visible
Parents
0
ajinkyab277
Certified Lead Developer
over 9 years ago
Hi Richard,
Difference function is the best way to identify such ids for delete.
But if you are not really want to hard delete the rows from database. Yo can also update the active flag to false after user removes the row, in this case you just have to use single 'write to data store' node.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
ajinkyab277
Certified Lead Developer
over 9 years ago
Hi Richard,
Difference function is the best way to identify such ids for delete.
But if you are not really want to hard delete the rows from database. Yo can also update the active flag to false after user removes the row, in this case you just have to use single 'write to data store' node.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data