Article Details
Id:16416
Product:finPOWER Connect
Type:NEW
Version:3.02.03
Opened:26/08/2019
Closed:02/10/2019
Released:22/11/2019
Job: J022829

Client Contact Method; update ValueSearch functionality

The Client Contact Method database table has a column ValueSearch that can be used to optimise searching for Email and Phone Numbers. This has been enhanced in version 3.2.3 as follows:

  • ClientContactMethod.ValueSearch
    • Was saving for all Contact Types, saving letters (upper cased), numbers and @.
    • Now only saves:
      • Valid Emails in upper case
      • Valid Phone Numbers in E164 format, i.e. +6468355237
  • Global Settings
    • Updated "Optimise" button under Global Settings, General group, Search page
      • This resets the value stored in ClientContactMethod.ValueSearch on database
      • Updates finBL.Settings.IsClientContactMethodValueSearchOptimised to True
        • This flag indicates whether the Client's ContactMethod.ValueSearch column has been optimised.
  • New Functions
    • finBL.ClientFunctions.GetCleanedEmail
    • finBL.ClientFunctions.GetCleanedPhoneNumber
  • Update Functions
    • Message Handler
      • CallerId updated to use new ValueSearch = much faster
        • E.g. localhost:5000/callerid?phonenumber=8355237
      • Updated finClientFunctions.GetCallerIdSearchResults
        • Much faster, but requires optimisation be run first
    • Client Functions
      • Updated to use ValueSaved, if data optimised
      • finClientFunctions.GetClientFromEmail
      • finClientFunctions.GetClientFromPhoneNumber