3CX V20 MsSQL Search Contacts

[LibertyX]

I have configured the Connection to our SQL Server and the "Lookup By Number" is working but the Search Contacts not.
The Test Funktion on the Admin Panel does only works for the Lookup by Number.

I know that there was a Tool for Windows to test the SQL Lookup but i can not find it.

 

[Evolute IT]

What variable did you use for the search contacts query? It should he the "[SearchText]"

 

[LibertyX]

Sure, for Search Contacts i use '%[SearchText]%' instead of '%[Number]%'

Lookup by Number

SELECT ID as contactid, COMPANY1 as CompanyName, FIRSTNAME0 as firstname, LASTNAME0 as lastname, EMAIL0 as email, PHONE0 as phonebusiness, MOBILEPHONE0 as phonemobile, FAX0 as faxbusiness FROM ADDRESSES WHERE PHONE0 LIKE '%[Number]%' or DIRECTPHONE0 LIKE '%[Number]%' or MOBILEPHONE0 LIKE '%[Number]%'

Search Contacs

SELECT id as COMPANY1, FIRSTNAME0 as firstname, LASTNAME0 as lastname, EMAIL0 as email, DIRECTPHONE0 as phonebusiness, MOBILEPHONE0 as phonemobile, FAX0 as faxbusiness FROM ADDRESSES WHERE FIRSTNAME0 LIKE '%[SearchText]%' or LASTNAME0 LIKE '%[SearchText]%' or DIRECTPHONE0 LIKE '%[SearchText]%' or MOBILEPHONE0 like '%[SearchText]%' or FAX0 LIKE '%[SearchText]%'

 

[Evolute IT]

Try with the variables instead. No clue why Number still works tho.

CONCAT ('%', @SearchText ,'%')

https://www.3cx.com/docs/sql-database-pbx-integration/#h.qdran8w17g1h

 

[LibertyX]

This i did in front of my post, does not work

No clue why Number still works tho.

It wil be change automatically