Configuring a basic 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.
-
Click the Table button and make a
selection.
This opens a Table Selection dialog box that lists all the tables/views found in the selected Database Connection. Only one table can be selected at a time. This is required.
-
Select the In and Out columns. These are required.
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 SQL Statement field shows the generated SQL statement and is read-only. This statement is automatically generated from Table, In, and Out.The generated SQL statement is similar to:
select columnOut1, columnOut2 from table1 where columnIn1=<columnIn1> and columnIn2=<columnIn2>
columnIn1
andcolumnIn2
are placeholders that represent the configured In columns. During runtime, the translation engine replaces placeholders with their corresponding real values.