How can I display more than 100 work items in the work list screen?

Products

• CA Identity Manager
• CA Identity Governance
• CA Identity Portal
• CA Identity Suite

Issue/Introduction

The worklist screen shows only 100 work items. How can it be changed to a different value?

Environment

Identity Manager 14.x
Standalone only

Cause

This value is hardcoded.  This will be restored to the default of 100 once any upgrade or Cumulative Patch is applied to the environment.

 

 

Resolution

Edit the file iam_im.ear\workflow.rar\META-INFa.xml as follows to raise the limit. At a time, the system displays only 100 work list items that are pending for approval. To view all the work items, you must change the  SQLQueryLimit property value from 100 to 0 in <APPSERVER_DEPLOYMENT_DIR>/iam_im.ear/workflow.rar/META-INF/ra.xml.

From

<config-property>
          <config-property-name>SQLQueryLimit</config-property-name>
          <config-property-type>java.lang.Integer</config-property-type>
          <config-property-value>100</config-property-value>
</config-property>

To

<config-property>
<config-property-name>SQLQueryLimit</config-property-name>
<config-property-type>java.lang.Integer</config-property-type>
<config-property-value>0</config-property-value>
</config-property>

 

Note: raising this limit too high can cause performance issues.