90 views

Symptoms


Loading Catalog Item variables of type Lookup Select Box can take a long time to pull up the drop-down options for the variable.

Cause


For variables that pull up data from Choice (sys_choice) table, if the variable type is set up as a Lookup Select Box instead of Select Box, the system runs a direct query on the entire sys_choice table and queries ALL the records in the sys_choice table instead of just the related table and field.

Resolution


Set the Variable type to Select Box, which provides the ability to point to the specific choice table and choice field, thus keeping the query narrowed down to just the needed data, for example, if the Select Box needs to display the incident. In the Priority field’s choice options, specify the choice table as Incident and the choice field as Priority.

Additional Information


For more information, see the product documentation topics Variable types and Troubleshooting Lookup Select Box variables.

Article Information

Last Updated:2018-06-01 00:52:14
Published:2018-05-14