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