Question
Infosys
IN
Last activity: 9 Jul 2018 4:55 EDT
How to identify customized OOTB rules in Application
I want to consolidate the OOTB rules which are saved into application ruleset and updated for application specific changes.
px and py starting rule names are identified with filter logic.
How i can find the rules list which are not containing px, py prefix rules?
Pegasystems Inc.
IN
Try utilize the property pxOriginalCreateSystemID
This holds the information of the system where record was originally created. For OOTB rule, it should be pega I guess.
Infosys
IN
Hi,
I can see the value saves the base Rule set name. But this properties not available in the table where I am running query to get the rule details(PR4_rules).
Accenture B.V
NL
You can try running the below query in DB directly...
You can try running the below query in DB directly...
select max(A.A8) as RuleName, max(A.A12) as pxObjClass, max(A.A2) as pxInsName, max(A.A5) as pyClass, max(A.A6) as pyClassName, max(A.A9) as OOTBRuleset, max(B.B10) as CustomRuleset,max(B.B4) as UpdateOperator from (SELECT max([pxObjClass]) as A12
,max([pxInsId]) as A1
,max([pxInsName]) as A2
,max([pxUpdateOperator]) as A3
,max([pxUpdateOpName]) as A4
,max([pyClass]) as A5
,max([pyClassName]) as A6
,max([pyInterface]) as A7
,max([pyRuleName]) as A8
,max([pyRuleSet]) as A9
,max([pyRuleSetVersion]) as A10
,max([pzClassType]) as A11
FROM [PRPC7].[PegaRULES].[pr4_rule_vw] A where (pyClassName not like 'ApplicationSpecific%') and pyRuleSet not like 'ApplicationSpecific%' group by pyClass,pxInsName) A, (SELECT max([pxObjClass]) as B1
,max([pxInsId]) as B2
,max([pxInsName]) as B3
,max([pxUpdateOperator]) as B4
,max([pxUpdateOpName]) as B5
,max([pyClass]) as B6
,max([pyClassName]) as B7
,max([pyInterface]) as B8
,max([pyRuleName]) as B9
,max([pyRuleSet]) as B10
,max([pyRuleSetVersion]) as B11
,max([pzClassType]) as B12
FROM [PRPC7].[PegaRULES].[pr4_rule_vw] where (pyClassName not like 'ApplicationSpecific%') and pyRuleSet like 'ApplicationSpecific%' and pyRuleAvailable='Yes' group by pyClass,pxInsName) B where A.A2 = B.B3 group by B.B6, B.B3