How to populate newly exposed columns for large volume of cases
Hello!
We have a requirement to create and fill new properties for all Work Objects, even for old and resolved. This fields can be filled by using WO history.
The problem is the count of WOs. There is like 5 000 000 objects to be updated. This can take like 32 hours or more.
So we are searching a way to do it and do not affect users. Is there a recommended way? Or OOTB solution?
Regards,
Nikolay Salnikov
Accepted Solution
Pegasystems
US
(admin: I would recommend a title change for this, perhaps something like "How to populate newly exposed columns for large volume of cases").
We have had to do this a couple of times for our application. There are a couple of things to consider: technical approach and timing of execution.
There are some different technical approaches you could take: write Pega activities to populate the data and commit the items OR write database scripts.
I would recommend that if possible you create a clone of your production system to do a dry run of your data population so that you can make sure it works as expected and so that you can get an idea of the time that it will take to execute completely on production.