Drop List Limits

This feature provides a number of drop list guardrails designed to help you avoid potential performance and stability issues related to loading drop lists that contain a large number of values.   This feature is controlled by a set of properties.

• Property - glog.droplist.limit.enabled - turns on the drop list guardrail feature – default is false, no limits.
• Property - glog.droplist.limit.max - sets an overall maximum limit when feature is enabled, default is 1,000.
• Property - glog.droplist.limit.glog.server.query.order.OrderReleaseRefnumQualQuery set to 100, is an example of a query specific configuration that you can configure, in this case this property setup will limit the order release reference number drop list to 100.

This feature provides the option to limit, when necessary, the number or records loaded into a drop list.  Loading an excessive number or records into a drop list can lead to system instability and performance issues.

Steps to Enable

To take advantage of this feature you will need to - at a minimum - set the property - glog.droplist.limit.enabled - to true, this property turns on the drop list guardrail feature, the default is false.

You can also change the default  maximum value of 1,000 using the property - glog.droplist.limit.max. 

In addition you can configure additional controls at the query level - if required - for example - glog.droplist.limit.glog.server.query.order.OrderReleaseRefnumQualQuery set to 100, will limit the order release reference number drop list to 100.

The Property Sets page is accessed via Configuration and Administration > Property Management > Property Sets. 

NOTE: Only the DBA.ADMIN user can access and use the Property Sets page.

Key Resources

• For additional information about these and other properties - see the Property Tree.  This page is accessed via Configuration and Administration > Property Management > Property Tree.