Removing deleted docs from a process variable

bojanb over 7 years ago

Hi,
Do you have any idea how to remove all of the documents from a process variable that were previously physically deleted?
The deleted documents in the documents process variable (multiple) are shown as random numbers (for e.q. "85385235"...)
Please help me remove them and leave only the documents that are still valid (not deleted). Using Appian functions (not other plugins/smart services) is preferred.
Thank you in advanced...

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 7 years ago

@bojanb How about applying the fn!intersection on the array 1 (that has existent and non-existent document ids) and the array 2 (that has existent document ids and the random numbers of the deleted documents)? The function output are those values that are common to both arrays which are existent document ids.

Prior to applying the above-mentioned function, make sure that the arrays of same data type (cast the data accordingly) are sent as its arguments. Let me know if you have any follow up questions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 7 years ago

@bojanb How about applying the fn!intersection on the array 1 (that has existent and non-existent document ids) and the array 2 (that has existent document ids and the random numbers of the deleted documents)? The function output are those values that are common to both arrays which are existent document ids.

Prior to applying the above-mentioned function, make sure that the arrays of same data type (cast the data accordingly) are sent as its arguments. Let me know if you have any follow up questions.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data