AIM 5.8 - Lookup (Header Fields)
- Taylor Treece (Unlicensed)
Analytics
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.
Related content
Copyright © CASO Document Management
All product names, logos, brands, and trademarks featured or referred to on this page are the property of their respective trademark holders. These trademark holders are not affiliated with, nor do they sponsor or endorse this website or the products/services offered unless explicitly stated otherwise.