CRM MSSQL integration 9 digit phone number

Status
Not open for further replies.

DanielMarek

Customer
Joined
May 29, 2017
Messages
3
Reaction score
0
Hello in CZ we use 9 digit numbers +420777666555 but when i use mssql integration with WHERE tel LIKE '%[Number]%' then 3cx create query with syntax
WHERE tel LIKE '%666555%' - only 6 digits , were i can change 6 digits to 9 digits ideal is full number with prefix +420 13 chars

Thank you for help
 
Hello @DanielMarek,

You can control this from the 3CX Console > Advanced > Contacts > Options. From there you specify how you want to match phone numbers. You can use "Match Exactly" to match the entire number, or enter the number of digits, and then the last N digits will be considered.

Kind regards.
 
Status
Not open for further replies.

Latest Posts

Forum statistics

Threads
112,324
Messages
591,897
Members
165,475
Latest member
lastshadow