Question
Cognizant Technology Solutions
IN
Last activity: 10 Dec 2019 7:19 EST
Storing work objects in a user created table
How to store the work objects in a user created table?
Pegasystems Inc.
IN
To perform this you will have to map the class of the work object to your custom table that you have created.
Configure/Designer Studio > Data Model > Classes & Properties > Database class Mapping
Use the New External Database Table Class Mapping button (for externally mapped classes only) to create a new database table instance or edit an existing database table instance and properties that associate a class (and its derived classes) with an existing relational database table or view in the Pega database or an external database.
Another option is:
-- Go to Records > SysAdmin > Database Table
-- Select the class which you want to map to a different table.
To perform this you will have to map the class of the work object to your custom table that you have created.
Configure/Designer Studio > Data Model > Classes & Properties > Database class Mapping
Use the New External Database Table Class Mapping button (for externally mapped classes only) to create a new database table instance or edit an existing database table instance and properties that associate a class (and its derived classes) with an existing relational database table or view in the Pega database or an external database.
Another option is:
-- Go to Records > SysAdmin > Database Table
-- Select the class which you want to map to a different table.
-- Select the Database and enter the Table name.
Standard Chartered Bank
IN
1.Using the structure of pc_work create a dedicated table
2. Map the Database Table instance of the work class pointing to newly created table.
Please find the below link for more info https://community.pega.com/sites/default/files/help_v72/database/database2/databasetableswork.htm