Mahesh Chandra Somepalli (MaheshSomepalli)
Mahesh Chandra Somepalli
MaheshSomepalli Member since 2015 2 posts
Posted: May 10, 2017
Last activity: October 16, 2018
Posted: 10 May 2017 1:31 EDT
Last activity: 16 Oct 2018 12:03 EDT

To delete lower versions Rulesets after Skimming, Please let us know the tables

We want to delete the lower version rules from the system after skimming

what are all the tables and SQL queries we should use to delete the lower version rules, All at a time. Instead of individual running of Delete ruleset wizard

Scenario :
We have skimmed the Portal Ruleset to new major version 03.

We want to delete all the lower version rules (01-xxxx and 02-xx-xx).

What are the tables we should look to delete the records?

What will be the Delete queries with where clause?

Any post deployment steps after deleting the records from DB?

Note: There are few rules in pega (Rule-Obj-Class, Rule-Library etc ) which are not version specific and they only belong to RuleSet, those should not be deleted from the system.

***Updated by moderator: Lochan to add Categories***

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

Case Management Data Integration
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.