Description:
The worklist screen shows only 100 work items. How can it be changed to a different value?
Identity Manager 14.x - on-premise version
This value is hardcode, also it can be restored to the default value if a Cumulative Patch or HF is applied to the environment.
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.