SA Table Code Value Setup - Search (Autocomplete) overview

System Administrator > Setup > Table Code Value

Use this page to customize the format of Elasticsearch-based search results that display in autocomplete fields.

Caution: 
Only developers should create or modify Search (Autocomplete) records.

You use standard table field names from the Distribution SX.e code to modify the format of the output.

To obtain the field names, you can use Infor Reporting to run an ad hoc report against the Distribution SX.e database. You can also use the SX Dictionary Help tool. It is available on the Infor Download Center. You may be required to purchase Infor Reporting and the SX Dictionary Help separately.

When you specify the format, you must place the field names in curly brackets. When a search is conducted, values replace the field names. If a value is not available, the space that is allocated for the value is left blank. You can also add spaces and characters. They are displayed as entered.

This is an example of the autocomplete search format for a vendor:

  • {vendno} - {name}

This is an example of the output:

  • 2164 - Grandview Plumbing Distributors

Records for default search formats are included in standard Distribution SX.e. The format is in lower case letters and the repository is typically an acronym.