Configuring an advanced SQL database lookup
- Select Advanced Database Lookup.
- Open the Database Connection menu and select a database. The list includes all configured database connections, including master (primary) site connections. This is required.
- For Type, select SQL.
-
In the SQL
Statement field, you can directly specify any valid query
statement. You can also click Configure to open the Inbound
(Outbound) SQL Statement Configurator dialog box where you can
compose the query statement. This is required.
This dialog box provides functions to help you compose the SQL statement.In the Inbound (Outbound) SQL Statement Configurator dialog box, all real condition values must be replaced with the appropriate placeholder. SQL content can span multiple lines and must be a query statement. Otherwise, the GUI prompts an error message.
-
Select the In and Out columns. These are required.
In/Out show the names of specified table/view columns. Clicking the button opens the Column Selection dialog box that lists all the columns in the selected table/view. Multiple selections are permitted. Selected values populate the field as a comma separated list.The Out field shows all the columns that are the output of the Translation Table action.