Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Bryan Chen (BryanC97)
Infosys Limited
US
BryanC97 Member since 2017 4 posts
Posted: Jul 25, 2018
Last activity: Nov 2, 2019
Posted: 25 Jul 2018 13:52 EDT
Last activity: 2 Nov 2019 15:36 EDT
Closed
Solved

Creating a new table for a class?

Is there any way for me to get Pega to create a table in PegaDATA specifically for a class to use?

When I create a new class, it usually maps to pr_other. Let say, I want a table besides pr_other

The class in question is TGB-HRApps-Data-TestData

I basically want a table specifically for all instances of this class, so I can do things like running a report definition on exposed properties of the class, and doing keyed access. I don't want my class instances to be mixed up with instances of a different class in pr_other

To see attachments, please log in.
Data Integration

Accepted Solution

Posted: 6 years ago
Posted: 25 Jul 2018 14:56 EDT
Basavaraj Kadakol (BASAVARAJ)
PEGA
Senior Manager of Technical Support Engineering
Pegasystems Inc.
AU

Hi Bryan,

I don't think there is an option to create a table directly from the prpc, you will have to create from the db and then run  the db table class mapping.

Hope this helps you.

Regards,

Basavaraj

To see attachments, please log in.
Posted: 6 years ago
Updated: 6 years ago
Posted: 25 Jul 2018 15:03 EDT
Updated: 25 Jul 2018 15:02 EDT
Bryan Chen (BryanC97)
Infosys Limited
US

Hey Basavaraj,

 

I was afraid that this would be the answer. I had a feeling that there are no options to directly create tables in PRPC.

 

Thanks a lot for the insight,

Bryan

To see attachments, please log in.
Posted: 5 years ago
Posted: 2 Nov 2019 15:35 EDT
Chris Shield (FloridaChris)
CompTech Associates

CompTech Associates
US

Pega can create the corresponding table when creating a new class. 
I use DataTableEditorReport to configure the properties. 

  1. Create a data class
    1. Select concrete 
    2. Select does not belong to a class group
    3. Set the key name
    4. Save the class

Next save DataTableEditorReport report into your new class.

  1. Configure DataTableEditorReport to use your properties
  2. Include your key as one of the properties
  3. Save the report.

Next

  1. Open the class in the data designer (one of two ways)
    1. In the app explorer right click on the class name and click on create properties
    2. On class definition, click on drop down next to class name, select view in data designer.
  2. Click on records tab
  3. The following message will appear
    1. Warning : We were unable to create columns to match the new properties added. This will cause performance problems when using this data type. Please click here to fix this.
    2. Click on here.

Pega will optimize the properties and generate the table with the same name as the class up to 27 characters, prepending pr_ 

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice