Slow Select field if report data has a lot of rows in Service Catalog

Products

• CA Service Catalog

Issue/Introduction

When using a filter text into the select box nothing happens for 10-20 seconds. Then the result appears. After that it is fast enough.

There are fields, where we have to select an item from these tables, and the select query is against a very large table.

 

 

Environment

Release : 17.3

Component : CA SERVICE CATALOG

Resolution

Any computation of the report variable parameter forces a full load of the table; instead this should use a straight passing of it, using the form

$({'val': _val}) 

This then lets the query optimize at the database level, including the use of "top x" in select queries, to deliver greater performance. This form is documented here:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/ca-service-management/17-3/using/service-catalog-management/manage-forms/perform-automated-tasks-in-form-fields/use-javascript-functions-in-fields.html