Question
Commonwealth Bank
IN
Last activity: 6 Mar 2023 2:14 EST
How to change an Existing class mapping from pr_other table to specific db table
I am trying to create a new db table and map it to already created data class which was previously an abstract class. when I am trying to create a database class mapping for the same class it throws an error. Please let me know how can I assign a new db table for an already existing data class which was mapped to pr_other table previously.
I saw one resolution where it said to change the pr_other table itself but i dont want to make any changes to the pr_other table here.
Thanks!
TSPi
US
https://support.pega.com/question/how-change-class-mapping-prother-table-new-table-same-schema
check this
Areteans Technology Solutions Pvt. Ltd.
IN
@BhabaniPrasadDAs you said that the class for which you are changing a mapping was a data class which was previously an abstract class. I hope before doing a DB table mapping you might have changed the abstract class to a concrete class. As we can map a table only with a concerete class. If this is not done then please follow the below steps hope this will solves your problem.
1. Change the class type from abstract to concerete
2. Then go to DB table mapping rule and change the table name if already there of not then create a new rule and do the table mapping with the class.
3. Save both the instances class and DB table mapping as well.
Updated: 6 Mar 2023 2:28 EST
Rulesstack Private Limited
IN
Hi @BhabaniPrasadD,
1) Create a table in the database as per your requirement( name)by using SQL query.
2) Open class definition Sysadmin mapped the class to create a table
Please find the below link for your better understanding
https://support.pega.com/question/how-change-class-mapping-prother-table-new-table-same-schema
Thanks
Bits in Glass
IN
@BhabaniPrasadD Also please make sure apart from the OOTB pega properties, all the columns you have created for your requirement in the previous table exists in your new table.