How can I see more than 100 work items in the work list screen?
search cancel

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

book

Article ID: 25822

calendar_today

Updated On:

Products

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

Issue/Introduction

Description:

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

Environment

Identity Manager 14.x - on-premise version

Cause

This value is hardcode, also it can be restored to the default value if a Cumulative Patch or HF is applied to the environment.

 

 

Resolution

Edit the file iam_im.ear\workflow.rar\META-INF\ra.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.