sql integration number not proper

[kvinay]

Hello,
i am trying to add Lookup SQL Statement: using https://www.3cx.com/docs/sql-database-pbx-integration/ but when i test it convert my NUMBER into 6 digit
suppose i enter 9874563210 it gets converted into 563210



this is my query
SELECT id as contactid, first_name as firstname, last_name as lastname, phone as phonebusiness FROM contacts WHERE phone = '[Number]'
do i need to do something else or my query is not correct ?
Thanks

 

[edossantos]

You need to change the configuration from the 3CX Console > Advanced > Contacts > Options > Match exactly.

 

[kvinay]

thank u