Configure Lookup for Database > Name/Value > Quick Config tab

Configures a lookup using the existing data format from your data source.

Figure: Quick Config tab

Quick Config tab

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?

How to Start

  1. On the Application Explorer screen, do one of these:
  2. Do one of these:
    • Add your form control:
      1. On the eForm Builder screen, in the Toolbox, open one of these tabs:
        • Common Controls Common Controls icon
        • Advanced Controls Advanced Controls icon
        • Telerik Controls Telerik Controls icon
      2. On your tab, drag one of these controls onto your form:
        • Auto-Suggest Auto-Suggest icon
        • List Box List Box icon
        • Subform Subform icon
        • Check Box Check Box icon
        • Auto Lookup Auto Lookup icon
        • List View List View icon
        • Pop-Up Select Pop-Up Select icon
        • Drop-Down List Drop-Down List icon
        • Auto-Suggest Auto-Suggest icon
        • Chart Chart icon
        • Data Grid Data Grid icon
        • Drop-Down List Drop-Down List icon
        • Data Grid Data Grid icon
        • Multi-Select List Box Multi-Select List Box icon
    • Change your form control:
      1. On your eForm, click the control, and click Edit Edit icon.
  3. On the Configure tab, click Add Lookup Add Lookup icon.
  4. On the Select Data Source Type screen, select Database Database icon, and click Next.
  5. On the Lookup Details screen, select Name/Value, and click Next.
  6. On the Configure Lookup screen, click the Quick Config tab.

Fields

Field Name Definition

Schema

Function:
Specifies your database schema.
Accepted Values:
A schema name from the list.

When you select a database, the schemas associated with the database show in this field.

Default Value:
None

Table

Function:
Specifies the name of the your database table.
Accepted Values:
The name of your table.

When you select a schema, the tables associated with the database show in this field.

Default Value:
None

Name

Function:
Specifies the column name of the database table in a key-value pair.
To Open this Field:
  1. Select a table from the Table list.
Accepted Values:
The column name from the list.

When you select a database table, the columns and its values associated with the database table show in this field.

Default Value:
None

Value

Function:
Specifies the value for a database column in a key-value pair.
To Open this Field:
  1. Select a table from the Table list.
Accepted Values:
The value from the list.

When you select a database table, the columns and its values associated with the database table show in this field.

Default Value:
None

Column Name

Function:
Specifies the name of the database column.
To Open this Field:
  1. Click Add Filter Add Filter icon
Accepted Values:
A valid database column name.
Default Value:
None

Operator

Function:
Specifies the operator to use in filter.
To Open this Field:
  1. Click Add Filter Add Filter icon
Accepted Values:
  • In
  • !=
  • =
  • >
  • <
Default Value:
=
Limitations:

The In operator is available in these releases:

Filter Condition - Value

Function:
Specifies one or more values for the column or process data variables that contains the column value.
To Open this Field:
  1. Click Add Filter Add Filter icon
Accepted Values:
One or more column values.
Default Value:
None
Accepts Process Data Variables:
Yes
Limitations:

The option to use more than one value is available in these releases:

Delete Filter Delete Filter icon

Function:
Deletes the filter condition.

Filter Condition - Sort By

Function:
Specifies the name of the column to sequence the query results.
Accepted Values:
The name of your list column.
Default Value:
None

Filter Condition - Sort Order

Function:
Specifies the sort order for the result set.
Accepted Values:
  • Ascending
  • Descending
Default Value:
Ascending