About Multi-Column Attribute Filtering - Designer - Foundation 23.1 - Foundation 23.1 - Brainware - external

Both the Brainware V3 core engine and the Remote Matching Service options support multi-column attribute filtering. By default, the Associative Search Engine performs a search against all search pool records. The multi-column Filter attribute can limit the search to records with specific attribute values, such as “Washington” for city. Attribute values are case-sensitive.

You must specify attribute values for each Filter column in script. For example, you can use this feature to filter Verifier Vendor search results or within the field PreExtract event to limit allowable RTS Vendor values. First use the ClearFilterAttributes method to clear all attributes of a previous search, and then configure the filters using the AddFilterAttribute method. Only one filter attribute may be filtered on multiple values (OR operator). Subsequent filter attributes are connected with the AND operator.

To use the feature with the Verifier search button, configure the .SearchField or the .AnalyzeField call as shown in the following script.

Example: Configure the SearchField or the AnalyzeField

Dim theSupplierSettings As Object
Set theSupplierSettings = FieldAnalysissettings
Dim theAdsSettings As CDRADSLib.SCBCdrSupExSettings
Set theAdsSettings = theSupplierSettings
theAdsSettings.ClearFilterAttributes
theAdsSettings.AddFilterAttribute "SupplierName", "VAN"
theAdsSettings.AddFilterAttribute "SupplierName", "VAN3"

For Associative Search filtering with RTS, configure the extension in the VendorName or VendorASSA field preExtract event. This enables the filtering before the attribute search is implemented in the extraction.

Example: Configure the preExtract event

Private Sub VendorName_PreExtract(pField As SCBCdrPROJLib.SCBCdrField, pWorkdoc As SCBCdrPROJLib.SCBCdrWorkdoc)
   Dim theSupplierSettings As CDRADSLib.SCBCdrSupExSettings
   Dim theDocClass As SCBCdrDocClass
   Dim theAnalysisSettings As ISCBCdrAnalysisSettings
   Dim theObject As Object
   Set theDocClass=Project.AllClasses.ItemByName(pWorkdoc.DocClassName)

   theDocClass.GetFieldAnalysisSettings "VendorName","German", theAnalysisSettings
   Set theObject = theAnalysisSettings
   Set theSupplierSettings = theObject

   theSupplierSettings.ClearFilterAttributes()
   theSupplierSettings.AddFilterAttribute "SupplierName", "VAN"
   theSupplierSettings.AddFilterAttribute "SupplierName", "VAN3"
End Sub

For more information, see "SCBCdrSupExSettings methods and properties" in the Brainware Intelligent Capture Scripting Help.