How to clone only the closed records?

[Suggy]

As part of cloning, I want to include only the inactive records to be cloned from source instance to target instance.

ex - only closed incident, problem, change records should be cloned. And records which are open/active should not cloned.

Is that possible?

[Shivalika]

Hello @Suggy 

Add a preserver on these tables with condition like state is not closed. 

Then it will preserve all the other records apart from closed records and only closed records will be cloned from your source instance to target instance. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOw

NeEISQCY

[Suggy]

Hi @Shivalika my question is totally different. Preserve will not at all work for my requirement

[Suggy]

I have updated my question for better clarity

[Shivalika]

Hello @Suggy 

So you only want to Override the closed records, then what do you want to do with the existing active records in your instance ? Do you want to delete them ? Or let it be as it is ? 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this questions from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwNeEISQCY