Idea

2
Replies
65
Views
BalajiKannadhasan Member since 2017 5 posts
BB&T
Posted: November 1, 2017
Last activity: November 23, 2017

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***

Data Integration SR Exists
Share this page LinkedIn