Rajarshi Dutta (RajarshiD)
Securities and Futures Commission
Pega Consultant
Securities and Futures Commission
RajarshiD Member since 2015 4 posts
Securities and Futures Commission
Posted: June 5, 2020
Last activity: June 5, 2020
Posted: 5 Jun 2020 3:01 EDT
Last activity: 5 Jun 2020 3:03 EDT

Major Version Ruleset Skimming

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. What is the best practice for deployment in case of moving to higher environment post skimming?

Pega Platform Case Management Communications and Media Senior System Architect
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.