Database Lookup - Infiniworx - Foundation 23.1 - Foundation 23.1 - AnyDoc - external

Infiniworx
Platform
AnyDoc
Product
Infiniworx
Release
Foundation 23.1
License

The database lookup rules options are:

Option

Description

FuzzyLookupMatchPercent

Specifies the percentage of fuzzy logic to use.

UseFuzzyLookup

If set to false, it returns either an exact match or nothing from the reference table. If set to true, it uses fuzzy matching to return one or more close matches from the reference table.

ConnectionString

Connection information to the database. Includes information like the data provider, data source, password, login ID, etc.

Table

Database table name used for data field validation.

Column

Database column name used for data field validation.

ShowTableEntriesOnError

Specifies if a dialog with all the table entries should appear if the data field fails validation.

SortColumn

Database column name used to sort the exception handler table entries.

DisplayColumns

Database column names to display in exception handler dialog.

LookupResultMappings

Maps database lookup results to data fields.

EnforcementFrequency

Specifies the frequency the rule will be enforced.

EnforcementLevel

Specifies the rule enforcement level.
  1. Click in the ConnectionString area and select the Browse button. The Choose Connection String window is displayed.
  2. Select the appropriate database source from the drop-down menu.
  3. Enter the information required to log into the database.
    Note:

    Set up and login to a database varies depending on the type of database being configured.

  4. Click Test Connection to validate the database.
  5. Once the database is selected and tested, click OK.
  6. Select the correct Table to use from the drop down list.
  7. Select the correct Column to use from the drop down list.
  8. Add other rules as needed, click OK to finish.