Add a Fuzzy Search action

Fuzzy Search is a technique of finding strings that closely (but not exactly) match a pattern in a "fuzzy" database, which is a single table or view exported from a relational database.

A fuzzy database is relatively static and contains sensitive data in a table or view from a large relational database that is on a secured network and not readily available. A fuzzy index enables fast searching and matching of text values using non-exact string matching in record sets or in specific columns.

In TotalAgility, add a Fuzzy Search action to a document validation form to perform a fuzzy search in a Validation activity. For example, if you enter 9600 as search text, all matching records (partial or complete) appear, irrespective of fields.

You can configure Fuzzy Search actions to apply filters to columns of the Associative Search database.

Note the following:

  • It is mandatory to configure a remote fuzzy database in Kofax Search and Matching Server (KSMS) and Transformation Designer (TD) to add and execute the Fuzzy Search action in TotalAgility.

  • The Fuzzy Search action is available only for a document validation form.

  • The Fuzzy Search action allows user to progress on fuzzy search; however any other actions that are configured to come after the Fuzzy Search action still continue to run and do not wait for the user to complete the fuzzy search.

  1. On the Form Modeling bar, click Actions.
  2. On the Actions page, click Add Generic Add.
  3. On the Type list, select Fuzzy Search.

    The list of document fields appears.

  4. Enter a Name and Description for the action.
  5. Optionally, configure a unique action for each language separately. See Configure multilingual actions for a form or control for more information.
  6. On the Data Source list, select a data source:

    A list of fields for the selected data source appears.

    • If you select an Associative Search database, a Filter column appears next to the Value column in the Mappings table. You can configure filters for each column of the Associative Search database (which the Fuzzy Search action displays as rows).
    • If you select a data source other than an Associative Search database, the Filter column is hidden.

    Note The Data Source list only appears if the database is configured in Kofax Search and Matching Server (KSMS) and Transformation Designer (TD).
  7. Select the "Number of records to return" at runtime.
  8. In the Mapping table, configure the following columns:
    1. To map a form field to the database field, consume the field in the Value column.
    2. To specify filters for those columns that are filterable, type or consume a form or global variable in the Filter column.
      Note Multiple columns may have filter values if allowed by the configuration of the database.

    At runtime, the selected record appears in these form fields.

  9. Click OK.

    The newly created action is added to the table.

  10. Click Save.
  11. Associate the action with the control to trigger this action. To call the Fuzzy Search action upon form load, associate the action with the form. See Associate an action with a form or control for more information.