Newly added property is not appearing when open the work object.
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.
It is working for reports because the value is being fetched from the exposed column to populate in the report where as WO is concerned Pega will make use of blob to open the object on to the clipboard which doesn't have the updated value updated via sql.
Write an activity to loop all the WO's : do a obj-open-by-handle --> Property-Set --->Obj-save and finally commit. this way both the blob and exposed column will be in sync.