Map class instance to other table than "pr_other"
Hello,
I have created an abstract class. Then i changed it to Concrete class.
I checked the the box "Automatically generate a unique ID for records of this type" to have a primary key.
The warning "Instances of this class save to the pr_other table, which has few properties exposed as columns. Consider mapping this class to a different table ." appeared.
So my question is :
how map my class instance data to an other table than "pr_other" in order this class would have this own DB table ?
Hello,
I have created an abstract class. Then i changed it to Concrete class.
I checked the the box "Automatically generate a unique ID for records of this type" to have a primary key.
The warning "Instances of this class save to the pr_other table, which has few properties exposed as columns. Consider mapping this class to a different table ." appeared.
So my question is :
how map my class instance data to an other table than "pr_other" in order this class would have this own DB table ?
Pegasystems Inc.
IN
Hi Adel,
It's a general class warning , when ever a Class is created with keys it will expect a table mapping for the class in DB . if it not able to find the mapping in inheritance too , then it will map the class to pr_others by default and store the instances of the class on it .
If you need to overcome "Instances of this class save to the pr_other table which has few properties exposed as columns. Consider mapping to a different table." this warning, create a table in the PegaRules DB ,Column names similar to properties (Pega recommends tables to have pzInskey, pxobjClass and pxInsName for better performance) ans a corresponding Data-Admin-DB-table for the Class and the table.
Hi Adel,
It's a general class warning , when ever a Class is created with keys it will expect a table mapping for the class in DB . if it not able to find the mapping in inheritance too , then it will map the class to pr_others by default and store the instances of the class on it .
If you need to overcome "Instances of this class save to the pr_other table which has few properties exposed as columns. Consider mapping to a different table." this warning, create a table in the PegaRules DB ,Column names similar to properties (Pega recommends tables to have pzInskey, pxobjClass and pxInsName for better performance) ans a corresponding Data-Admin-DB-table for the Class and the table.
Hope it helps.
Thanks
Pegasystems Inc.
IN
1. Create new DB table and update database table instance mapping by replacing pr_other with new table name. Create new columns and provide column external mapping at class level if column name is not same as property name or if mapping to embedded properties. For property name same as column no need to provide external mapping explicitly.
2. If you want to use structure of pr_other. Create table with below query and perform other action as mentioned in point no. 1
Create table New_Table_Name AS (Select * from pr_other where pxobjclass="YourclassName");
Sopra Steria Group SA
FR
Hello,
Thanks for answering.
Our development environment is in the Cloud, so i can't create DB table and change mapping of database table instance.
What I can do ?
Pegasystems Inc.
IN
if possible create new definition for concrete class and delete old one. Pega OOTB will take care of creation of DB table.
CYBG
GB
Is there a way to disable the OOTB table creation? It is causing us a headache by creating hundreds of unused tables that our DBA has to manually drop.