Question
Areteans
GB
Last activity: 5 Jan 2018 9:06 EST
Which pega database table is store all the Rule-obj-activity instances
Which pega database table is store all activites
Pegasystems Inc.
IN
In ega RULES database,
Table Name | Example Parent Class | Key Structure | Notes
|
pr4_rule_sysgen |
Rule-Generated-Activity |
Applies To class, Activity Name. |
In ega RULES database,
Table Name | Example Parent Class | Key Structure | Notes
|
pr4_rule_sysgen |
Rule-Generated-Activity |
Applies To class, Activity Name. |
Internal facilities, generated Java |
Refer for more details:- https://docs.pega.com/database-management/database-tables-pegarules-database
Hope it answers your query, kindly notify by marking this post as answered.
Regards,
Asif
Areteans
GB
Thanks for reply but Rule-obj-activity class which contains all the activity rule is point to p4_rules.also the definition of Rule-Generated-Activity class says
This class contains activities generated automatically by your system in support of declaration processing.
You can review these activities, but do not attempt to create, modify, or delete them.
So Now i am confused between p4_rules table or its pr4_rule_sysgen table which database table contains all activity rules.
Pegasystems Inc.
US
The activity rule form will be stored in the pr4_rule which will be in XML format, but the generated java FUA will be stored in the pr4_rule_sysgen table. So to confirm you the created activity rule will be stored in the pr4_rule table only.
Hope its clear for you.
Pegasystems Inc.
IN
hi,
pr_other table
The pr_other table is the default destination for saved instances that belong to a class that is not mapped to any other table. To access the pr_other table, the system uses the catalog and schema specified for the pr4_base table as identified in the databases/baseTable/catalog and databases/baseTable/schema entries in the prconfig.xmlfile or Dynamic System Settings.
Each time an object is saved to the pr_other table, the system adds a PEGA0041 alert to the alert log.
Pegasystems Inc.
IN
Rule-Obj-Activity is class of the Activity rule. Rule-Obj-Activity is mapped to pr4_rule table. So instances of Activity rules are stored in pr4_rule table
DCS
GB
PegaRULES.pr4_rule is the table that contains the instances of Activities