Question
Virtusa
IN
Last activity: 15 May 2017 11:58 EDT
How do I create a new data table pr_index_ABCD in Pega 7?
Hi,
I created an Index class for reporting purpose - Index-ABCD. The table mapped to this table is pr_index by default. In order to use the properties (say, Dummy) in Index-ABCD class in a report definition (using declarative join)- I must expose these properties.
However, this would mean additional columns would be created in the database table pr_index corresponding to the property Dummy. This wont be a good approach as other applications might not need this additional column under pr_index.
I assume a better way would be to create a table pr_index_ABCD and have my columns there. How can I create this in Pega 7?
Accepted Solution
Pegasystems Inc.
IN
Hi,
If you have a class structure , something like : Sae-Sample-Work-UI
If you try to expose the property prop2, the declarative class, for that will automatically gets created, which can be checked from the property optimization wizard :
If you check the table mapped to that index class, that got created: you can see it as :
This is the ideal approach for creating the index class .
NCS Pte Ltd
SG
Hi Haritha,
Following your approach is not creating a index table but exposing the column in the work table and adding a external mapping in the class. Could you please reverify the approach and suggest if there is any setting which needs to be configured for this.
Thanks,
Saikat