Configuring a basic database lookup

  1. Open the Database Connection menu and select a database. The list includes all configured database connections, including master (primary) site connections. This is required.
  2. 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.
  3. 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 and columnIn2 are placeholders that represent the configured In columns. During runtime, the translation engine replaces placeholders with their corresponding real values.