Question
Atos Syntel
IN
Last activity: 19 Jan 2017 12:41 EST
How to change Class mapping from pr_other table to a new table in the same schema
Is there any wizard for changing the mapping of a class from pr_other table to a new table along with it's instances.
I need to do it for a data table, version - PRPC 7.1
***13/10/2016: Updated by moderator: Lochan to update post with original body text that was lost due to a PDN bug; Apologies for the inconvenience caused***
Pegasystems Inc.
IN
Atos Syntel
IN
I am assuming the new table should have the same columns as pr_other, please confirm.
Pegasystems Inc.
IN
Hi,
You need to go to data-admin-db-table instance ,open the record which is pointing to pr_other table and change it to the required name there . Please find below screen shot.
Atos Syntel
IN
I am assuming the new table should have the same columns as pr_other, please confirm.
Accepted Solution
PEG
GB
This depends on what is in pr_other.
If you have other customer classes mapped to pr_other and you've added properties to these customer classes and optimized them (hence generating another DB column), then you may not need that column for your new class.
As a safeguard you may want to do all columns, but you may want to look more closely at the ones that don't start with pz, py, or px.
I'm sure your database software may have some feature(s) which allow you to clone a table structure.
If not, hopefully they will allow you to see the SQL for the pr_other. The re-run this specifying your table name, and not forgetting to rename and indexes to the appropriate format for the new table.
Then after this, you should be able to follow Arun's suggestion from earlier, and hopefully all is done.
Pegasystems Inc.
US
Hi Dilipan,
We assume that you have a new table created in the schema and this table you want to map to some class -> if so then the table columns should be matching with the properties in your class definition.
For mapping, you can follow the suggestion given by arun.
Regards,
Mahesh