Cordial Saludo:
Envió informe de actividades CRM
SELECT T0.[CntctDate], T0.[ClgCode],T3.[CardName], T0.[Recontact], T4.[Name] as Tipo, T5.[Name] as Asunto, T1.[U_NAME] as 'Asignado a:',T2.[U_NAME] as 'Asigando Por:', Estado= CASE T0.[Closed] WHEN 'Y' THEN 'CERRADO' WHEN 'N' THEN 'ABIERTO' ELSE 'N/A' END FROM OCLG T0 INNER JOIN OUSR T1 ON T0.AttendUser = T1.USERID INNER JOIN OUSR T2 ON T0.AssignedBy = T2.USERID
INNER JOIN OCRD T3 ON T0.CardCode = T3.CardCode INNER JOIN OCLT T4 ON T0.CntctType = T4.Code INNER JOIN OCLS T5 ON T0.CntctSbjct = T5.Code WHERE T0.[CntctDate] Between [%0] and [%1] ORDER BY T0.[CntctDate] asc
A espera de sus comentarios.
Bluesky
