Question
Zensar Technologies Ltd
IN
Last activity: 16 Nov 2023 6:56 EST
External Mapping of Column/Property in Data Class
How to do external mapping of column that we manually created in database by running query for creating column in table to the class present in pega. Can someone please share the step-by-step configuration. Thanks in advance.
Accepted Solution
Updated: 16 Nov 2023 6:56 EST
NCS Pte. Ltd
SG
Hi @AbhishekC1725: If you have created the column names as same as the property names, it should work automatically. Please try by saving the class and database table instance. You can also do the mapping in the instance. Open the class, and navigate to external mapping tab to do the mapping. Please see this for details.
Thanks.
Zensar Technologies Ltd
IN
@ArulDevan Hi, Just want to know, that old data will come in the column after saving the class and database table instance. Or do we need to write activity to save all instances of that table?
NCS Pte. Ltd
SG
Hi @AbhishekC1725: No. To get the data from the BLOB to the exposed columns, you may need to use column population (or) utilities (or) it will get exposed to the columns when there is a next write operation to the specific row.
Thanks.