Hola Team,
Estamos trabajando en integrar el screen pop usando la opción sencilla de "Database MSSQL", para las llamadas telefonicas el screen pop funciona correctamente usando el número de entrada y creando el ContactUrl que hemos configurado y abre correctamente la pestaña en el browser con los datos del cliente.
Sin embargo cuando usamos LiveChat vemos que se hace la busqueda en 3CXmanagementsconsole.log , y sí encuentra el registro pero nunca ejecuta el screen pop, no vemos eventos en 3CxSystemService
Nota: el dominio xxxx.com del email lo editamos solo para fines de privacidad
La pregunta es , está integración de Database MSSQL , si soporta la busqueda por email de LiveChat correcto?
nuestra siguiente pregunta es para whatsapp, el screen pop se soporta en ese caso? , considera el número de teléfono?
Agrademos sus comentarios
El log 3CxSystemService.log para la llamada de voz muestra lo siguiente:
2026/02/05 13:15:49.325|0037|Debg| [Integration.Crm.Engine.SearchNumberScenarioProcessor] CRM: Executing SQL Query statement 'SELECT contactid as contactid, firstname, lastname, email, phonebusiness, phonemobile, faxbusiness FROM contacts WHERE phonebusiness LIKE CONCAT('%',@Number,'%') or phonemobile like CONCAT('%',@Number,'%') or faxbusiness LIKE CONCAT('%',@Number,'%')'.
2026/02/05 13:15:49.336|0037|Debg| [Integration.Crm.Engine.SearchNumberScenarioProcessor] CRM: The result of the SQL Query Execution is
'[{"contactid":1,"firstname":"Jesus","lastname":"Suarez","email":"[email protected]","phonebusiness":"55555555","phonemobile":"","faxbusiness":null}]' .
....
...
2026/02/05 13:15:49.338|0004|Trac| Call control transaction 3CXSystemService01.AttachConnectionDataAsync.44 has completed by notification:
Success(NotSpecified
:
Wconnection.1747
AttachedData=System.Collections.Generic.Dictionary`2[System.String,System.String]
LastChangeStatus=02/05/2026 19:15:49
RouteTarget=
ID=1747
HasAttached=False
AttachedData:
chid=00000000-01dc-96d3-d65f-fe0800000233
prevCall=0
prevLeg=0
sip_dialog_set_id=FAD5CE36E103EA2DE426BCAC58AD03C8-b2b_1-b2b_105716f47d
extnumber=5554330134
devcontact=sip:[email protected]
public_push_pickupinfo=FAD5CE36E103EA2DE426BCAC58AD03C8-b2b_1-b2b_1;to-tag=5716f47d;from-tag=2d4a574b111d9bc07d483e423c23ffb8
inbound_did=525592949720
inbound_did_rule=
participant_uid=00000000-01dc-96d3-d660-0fca000006db
msep_id=[email protected]:5482
public_lookup_displayname_override=Jesus Arellanes
public_crm_contact={
"FirstName": "Jesus",
"LastName": "Suarez",
"Email": "[email protected]",
"ContactUrl": "http://172.200.160.148:3001/dashboard/contacts/1/edit",
Esto es lo que vemos en 3CXmanagementconsole.log , confirmando que el Query es correcto y que si se encuentra el registro usando el email.
2026/02/05 13:26:04.518|0071|Debg| [Integration.Crm.Engine.SearchNumberScenarioProcessor] CRM: Executing SQL Query statement 'SELECT contactid as contactid, firstname, lastname, email, phonebusiness, phonemobile, faxbusiness FROM contacts WHERE email LIKE CONCAT ('%',@Email,'%')'.
2026/02/05 13:26:04.705|0071|Trac| [_3CX.Http] [9]+187.190.190.131 GET https://myweb.3cx.com.mx:443/ws/webclient?sessionId=52d1f57f-3cb2-4015***&pass=hidden - - -
2026/02/05 13:26:04.705|0071|Info| [Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware] No CORS policy found for the specified request.
2026/02/05 13:26:04.705|0071|Trac| [MyPhone.Client] NotificationHandlerConnected for client 0b6ad746-60e1-4386-a0d7-37bc4e7fe2ef(52d1f57f-3cb2-4015***)
2026/02/05 13:26:04.738|0041|Debg| [Integration.Crm.Engine.SearchNumberScenarioProcessor] CRM: The result of the SQL Query Execution is
'[{"contactid":1,"firstname":"Jesus","lastname":"Suarez","email":"[email protected]","phonebusiness":"555555555","phonemobile":"","faxbusiness":null}]' .
Estamos trabajando en integrar el screen pop usando la opción sencilla de "Database MSSQL", para las llamadas telefonicas el screen pop funciona correctamente usando el número de entrada y creando el ContactUrl que hemos configurado y abre correctamente la pestaña en el browser con los datos del cliente.
Sin embargo cuando usamos LiveChat vemos que se hace la busqueda en 3CXmanagementsconsole.log , y sí encuentra el registro pero nunca ejecuta el screen pop, no vemos eventos en 3CxSystemService
Nota: el dominio xxxx.com del email lo editamos solo para fines de privacidad
La pregunta es , está integración de Database MSSQL , si soporta la busqueda por email de LiveChat correcto?
nuestra siguiente pregunta es para whatsapp, el screen pop se soporta en ese caso? , considera el número de teléfono?
Agrademos sus comentarios
El log 3CxSystemService.log para la llamada de voz muestra lo siguiente:
2026/02/05 13:15:49.325|0037|Debg| [Integration.Crm.Engine.SearchNumberScenarioProcessor] CRM: Executing SQL Query statement 'SELECT contactid as contactid, firstname, lastname, email, phonebusiness, phonemobile, faxbusiness FROM contacts WHERE phonebusiness LIKE CONCAT('%',@Number,'%') or phonemobile like CONCAT('%',@Number,'%') or faxbusiness LIKE CONCAT('%',@Number,'%')'.
2026/02/05 13:15:49.336|0037|Debg| [Integration.Crm.Engine.SearchNumberScenarioProcessor] CRM: The result of the SQL Query Execution is
'[{"contactid":1,"firstname":"Jesus","lastname":"Suarez","email":"[email protected]","phonebusiness":"55555555","phonemobile":"","faxbusiness":null}]' .
....
...
2026/02/05 13:15:49.338|0004|Trac| Call control transaction 3CXSystemService01.AttachConnectionDataAsync.44 has completed by notification:
Success(NotSpecified
:Wconnection.1747
AttachedData=System.Collections.Generic.Dictionary`2[System.String,System.String]
LastChangeStatus=02/05/2026 19:15:49
RouteTarget=
ID=1747
HasAttached=False
AttachedData:
chid=00000000-01dc-96d3-d65f-fe0800000233
prevCall=0
prevLeg=0
sip_dialog_set_id=FAD5CE36E103EA2DE426BCAC58AD03C8-b2b_1-b2b_105716f47d
extnumber=5554330134
devcontact=sip:[email protected]
public_push_pickupinfo=FAD5CE36E103EA2DE426BCAC58AD03C8-b2b_1-b2b_1;to-tag=5716f47d;from-tag=2d4a574b111d9bc07d483e423c23ffb8
inbound_did=525592949720
inbound_did_rule=
participant_uid=00000000-01dc-96d3-d660-0fca000006db
msep_id=[email protected]:5482
public_lookup_displayname_override=Jesus Arellanes
public_crm_contact={
"FirstName": "Jesus",
"LastName": "Suarez",
"Email": "[email protected]",
"ContactUrl": "http://172.200.160.148:3001/dashboard/contacts/1/edit",
Esto es lo que vemos en 3CXmanagementconsole.log , confirmando que el Query es correcto y que si se encuentra el registro usando el email.
2026/02/05 13:26:04.518|0071|Debg| [Integration.Crm.Engine.SearchNumberScenarioProcessor] CRM: Executing SQL Query statement 'SELECT contactid as contactid, firstname, lastname, email, phonebusiness, phonemobile, faxbusiness FROM contacts WHERE email LIKE CONCAT ('%',@Email,'%')'.
2026/02/05 13:26:04.705|0071|Trac| [_3CX.Http] [9]+187.190.190.131 GET https://myweb.3cx.com.mx:443/ws/webclient?sessionId=52d1f57f-3cb2-4015***&pass=hidden - - -
2026/02/05 13:26:04.705|0071|Info| [Microsoft.AspNetCore.Cors.Infrastructure.CorsMiddleware] No CORS policy found for the specified request.
2026/02/05 13:26:04.705|0071|Trac| [MyPhone.Client] NotificationHandlerConnected for client 0b6ad746-60e1-4386-a0d7-37bc4e7fe2ef(52d1f57f-3cb2-4015***)
2026/02/05 13:26:04.738|0041|Debg| [Integration.Crm.Engine.SearchNumberScenarioProcessor] CRM: The result of the SQL Query Execution is
'[{"contactid":1,"firstname":"Jesus","lastname":"Suarez","email":"[email protected]","phonebusiness":"555555555","phonemobile":"","faxbusiness":null}]' .
