Question
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?
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
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 .