Skip to main content
Kofax

Is it possible to filter results from a Remote Fuzzy Database based on a value in a column?

Previously only Associative Search Databases supported filtering, however KSMS 6.7.0.3+ and 6.8.0.1+ added the ability to filter on a column value in Remote Fuzzy Databases as well. Using this functionality requires KTA 7.5.0.11+ or 7.6.0.1+.
3011140

Question / Problem: 

Is it possible to filter results from a Remote Fuzzy Database based on a value in a column?

Answer / Solution: 

Previously only Associative Search Databases supported filtering, however KSMS 6.7.0.3+ and 6.8.0.1+ added the ability to filter on a column value in Remote Fuzzy Databases as well.  Using this functionality requires KTA 7.5.0.11+ or 7.6.0.1+.

A column filter uses exact matching and can be set in a Fuzzy Search action, which is only available in a document validation form.

It can also be used via the SearchFuzzyDatabase  API.  A new property named FuzzySearchFilters has been added to the SearchQuery object.  It is a collection of FuzzySearchFilter objects, which has a property named FieldName to specify the field to which the filter applies, and a property named FilterText to specify what the column must contain to pass the filter.

 

Applies to:  

Product Version
KTA 7.6.0.1+
KTA 7.5.0.11+
KSMS 6.8.0.1+
KSMS 6.7.0.3+

 

Author:  Stephen Klancher