Fuzzy databases and filtering
You can use filtering to restrict the number of database records that are returned as candidate results by a fuzzy search.
Filtering value configuration is performed via scripting only. If you want to apply a filter value to a database lookup only, add the script to an event that occurs after extraction. For example, an event like ValidationForm_DocumentLoaded. To apply a script to a Database Locator, add the script to an event that occurs before extraction, such as Document_BeforeExtract.
The following is a script sample:
Private Sub Document_BeforeExtract(ByVal pXDoc as CASCADELip.CscXDocument)
Dim database As CscDatabase
Set database = Project.Databases.ItemByName("Database")
database.ClearFilteringItems()
database.AddFilteringItem("Department", "Name", "Company")
End Sub