Difference between revisions of "Precision Searching"

From All n One's bxp software Wixi

Jump to: navigation, search
Line 28: Line 28:
  
  
[[Category:Learning:Contact Centre]]
+
[[Category:Topic:Contact Centre]]
[[Category:Learning:Customer Relationship Management]]
+
[[Category:Topic:Customer Relationship Management]]
 
 
 
[[Category:Module Specific:Form Management]]
 
[[Category:Module Specific:Form Management]]

Revision as of 00:22, 10 November 2014

On large databases like searching induces an unacceptable overhead.


  • Database: 1.2 million customer records
  • Timing (with fuzzy searching): 16.2 seconds average
  • Timing (with precision searching): 2 seconds average
  • Timing (with precision searching and custom index): 0.59 seconds average


To enable precision searching for any client:


1. Main Menu > Database Management > Field Mapping > Select the campaign > identify the full field name of the column e.g strCDA_X_field_0_0


2. Main Menu > Database Management > Database – Primary Management > Campaign – Edit > Select the campaign > Advanced Options > Precision Search Fields


3. In this box put the field identified in item 1.


Multiple fields may be made precise using this method, simply add multiple fields separated by commas to this same box.


A precision match means that case sensitivity is also adhered to. i.e. "bxp software" is not the same as "business express"

If you need to enable a custom index, please contact your account manager to have the field indexed for you.