AIM 5.8 - Lookup (Header Fields)

Owned by Taylor Treece (Unlicensed)
Jan 14, 2023
1 min read

Lookup Settings configure SQL to look up the field value, a potential second value and then select which fields will be auto populated.

  • SQL Connection - SQL Connections are defined in the SQL Connections tab of the ECMT AP WF Admin page (See Chapter 6 SQL Connections)

  • SQL Table - SQL Table to be queried

  • Header Field 1 - First Workflow Header Field whose value is used in the query

  • SQL Column 1 - SQL Column to query based on Header Field 1 value

  • Header Field 2 - Second Header Field whose values is used in the query.

  • SQL Column 2 - SQL Column to query based on Header Field 2 value

  • Right Hand Screen - Maps SQL Values to the Workflow Fields

Be default, the max items shown on the lookup is 256.

If you wish to adjust this, you will need to adjust the ECMCombotable.js file located here:

C:\ProgramFiles (x86)\CASO\ECMT_AIM\assets\ECMComboTable

Line 18 for the “maxVisible” attribute will need to be adjusted as desired.

CASO Knowledge Base