Posted: 1 Nov 2017 11:38 EDT Last activity: 23 Nov 2017 9:18 EST
column populator utility cannot be run based on the status (non resolved) of a work object
Version: Pega 7.1.9
The Database Column Populator utility cannot be run just for the rows where pyStatusWork not like 'Resolved%'.
In the prpcUtils.properties file, there is a "SETTINGS FOR EXPOSE TOOL" section where parameters for the Database Column Populator utility can be specified.
The following parameters can be specified:
startKey, endKey, startDate, and endDate
However, there is no option to only process rows which are not like “Resolved” status based on pyStatusWork column, for example - pyStatusWork NOT LIKE 'Resolved%'
As we have large volume of records considering "Resolved" status, this fix/enhancement would help us to run the column populator utility to only process rows for non resolved cases which would minimize the server usage and improve the performance during the process.
Please Note: Please provide us if any hot fix readily available on this requirement
***Edited by Moderator Marissa to update categories***