Question
Morgan Stanley
IN
Last activity: 5 Dec 2016 8:44 EST
pxInteractionHistory data set does not have truncate option
I would like to clear off all my interaction history.
Usually when i run any data set it has trucate option. But i could not find it in the pxInteractionHistory data set rule.
Has the option been intentionally removed.. What is the easiest way to clear my history?
***Updated by Moderator: Marissa to update categories***
Areteans
IN
Hi,
I think you can delete by using DataSet-Execute with DeleteByKeys operation, something like this:
Can you try the above and let us know the update.
Thanks,
Bala
Pegasystems Inc.
NL
Interaction history was designed to be an insert-only data store, this is the reason why there is no operation or API. Naturally, IH can grow to proportions that make it difficult to manage; in this case, Pega supports archiving and purge of records in the source IH by providing step-by-step instructions that still assume that you are not approaching this lightly, and it is a calculated and planned operation–on the PDN, search for "Applying sample scripts for archiving and purging".