Question
Newly added property is not appearing when open the work object.
Hi Team,
I have requirement to add a new property to the work table and it should be available for reports, so a new property was created in work class and it is manually added to the work table via alter SQL querty. For the existing resolved work objects the data patch was done through update SQL, since resolved objects cannot be updated from PEGA with out re-opening.
Report are working as expected based on the newly added property but when a existing case is opened (review / re-open) the property was not appearing on pyWorkPage, however it is working as expected for newly created work objects.
Expecting a prompt response. Thank you.
Hi Satish,
The ideal way of achieving your requirement should be like below -
1. Create a property in work class as per your requirement.
2. Optimize the property using Optimization Wizard, so that a new column gets created in DB for the corresponding work table.
3. The newly added property will not be shown in pyWorkPage of Re-Opened cases, unless until it is referenced in case flows.
Since we are adding a new property all to gether, and in case of no DB updates for this column, the value would be null if you reference it in reopened cases.