Configure Lookup for Database > Multiple Columns

Configures the WHERE clause for your query.

Good to Know

Some information about third-party integrations is outside the scope of the AgilePoint NX Product Documentation, and it is the responsibility of the vendors who create and maintain these technologies to provide this information. This includes specific business uses cases and examples; explanations for third-party concepts; details about the data models and input and output data formats for third-party technologies; and various types of IDs, URL patterns, connection string formats, and other technical information that is specific to the third-party technologies. For more information, refer to Where Can I Find Information and Examples for Third-Party Integrations?

On the Application Explorer screen, do one of these:
- Open an eForm.
- Create an eForm in a Process.
Do one of these:
- Add your form control:
  1. On the eForm Builder screen, in the Toolbox, open one of these tabs:
    - Common Controls
    - Advanced Controls
    - Telerik Controls
  2. On your tab, drag one of these controls onto your form:
    - Auto-Suggest
    - List Box
    - Subform
    - Check Box
    - Auto Lookup
    - List View
    - Pop-Up Select
    - Drop-Down List
    - Auto-Suggest
    - Chart
    - Data Grid
    - Drop-Down List
    - Data Grid
    - Multi-Select List Box
- Change your form control:
  1. On your eForm, click the control, and click Edit .
On the Configure tab, click Add Lookup .
On the Select Data Source Type screen, select Database , and click Next.
On the Lookup Details screen, select Multiple Columns, and click Next.
On the Configure Lookup screen, click the Manual tab.

Field Name	Definition
Query	Function: Specifies the WHERE clause for your query with the conditions and logical operators Accepted Values: A valid SQL WHERE clause. A valid stored procedure. A valid SQL view. Default Value: None Example: SELECT PositionCode, FirstName, LastName, Email, City, StateCode, ZipCode FROM [appApplicants] WHERE PositionCode = ${PositionCode}
Validate Query	Function: Does a test to make sure the query is correct, and displays the error message if an error occurs. If the query completes, it shows View Formatted Data and View Raw Data options. When you click View Formatted Data, the Result field shows the result of the WHERE clause query in a table. If you click View Raw Data, the Result field shows the result in XML format.
Result	Function: Shows the result of the WHERE clause query in a table or XML format.