Question
Accenture
IN
Last activity: 5 Nov 2015 3:32 EST
Number of rules in a RuleSet
We know that, the number of rules in a RuleSet can see under Pega Button--> Application--> RuleSet Stack--> particular RuleSet ----> RuleSet version.
The Ruleset will be stored in a table called pr4_rule_ruleset. In which Table we can see the number of rules in particular rulset version?
I checked that... pr4_rule_ruleset table is having details only RuleSetName and RuleSet Versions and don't have number of Rules in a RuleSet version.
Where can i get those details within DB? ( I don't want to login into application to check that).
Accepted Solution
Pegasystems
IN
SELECT count("PC0".pzInsKey) AS "rulecount" FROM <schema_name>.pr4_rule_vw "PC0" WHERE "PC0".pyRuleSet = 'Pega-RULES' AND "PC0".pyRuleSetVersion = '07-10-01'
Above is an example to get the count for ruleset "Pega-RULES" and ruleset version "07-10-01". You can change the values to get the rule count by whichever ruleset and version you need
Pegasystems
IN
You might want to write a report against Data-Rule-Summary class to get that data. Please summarize the rules by grouping against pyRuleSet and pyRuleSetVersion.
Please take a look at the report pyRulesByRulesetVersion as well.
Pegasystems
IN
You can find the SQL that the report definition generates in the clipboard (pyReportContentPage.pxSQLStatementPost).
That said, you can try something like this
SELECT count("PC0".pzInsKey) AS "rulecount", "PC0".pyRuleSet AS "pyRuleSet", "PC0".pyRuleSetVersion AS "pyRuleSetVersion" FROM <schema_name>.pr4_rule_vw "PC0" GROUP BY "PC0".pyRuleSet, "PC0".pyRuleSetVersion
Make sure to put in the right schema name where this table exists (should be the PegaRULES schema in the DB).
Accepted Solution
Pegasystems
IN
SELECT count("PC0".pzInsKey) AS "rulecount" FROM <schema_name>.pr4_rule_vw "PC0" WHERE "PC0".pyRuleSet = 'Pega-RULES' AND "PC0".pyRuleSetVersion = '07-10-01'
Above is an example to get the count for ruleset "Pega-RULES" and ruleset version "07-10-01". You can change the values to get the rule count by whichever ruleset and version you need