Upgrading Get Next Work performance

To improve the performance of Get Next Work in querying assignments that were created in prior versions of Pega Platform, run the Skill count update for assignments utility.

After you upgrade Pega Platform, run the Skill count update for assignments utility to populate the new pxRequiredSkillsCount property with the amount of skills that each assignment requires.

It also creates the GetNextWork_UsepxRequiredSkillsCount dynamic system setting and sets its value to true.

Note: You do not need to immediately upgrade Get Next Work performance. As older assignments are resolved, newer assignments will have the upgraded performance applied.
  1. In the header of Dev Studio, click Configure > System > Release > Upgrade > Upgrade Tools.
  2. In the General Utilities section, click Skill count update for assignments.
  3. Click Run utility.