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
2010 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
Conor Cahill
Certified Lead Developer
over 9 years ago
use the difference() function on the id field of both arrays. Ids that are in your original array but are missing from the edited array will be the deleted items.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Conor Cahill
Certified Lead Developer
over 9 years ago
use the difference() function on the id field of both arrays. Ids that are in your original array but are missing from the edited array will be the deleted items.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data