Good Morning, Afternoon, or Evening,
I have been attemptiong to create a Query based on a Activity.
The query is very similuar to the Activities Overview, there are a few changes.
The customer server reps want to see the Notes along with additional data.
Here is the query so you can see what I am trying to do.
SELECT T0.ClgCode as ActivityCode, T0.Recontact as Date, T0.BeginTime as Time, T2.U_NAME as DDTContact, T0.Action as Activity, T1.CardName as BP, T0.CntctCode as CustomerContact, T0.Details as Remarks, T0.Notes as Content FROM OCLG T0 INNER JOIN OCRD T1 ON T0.CardCode = T1.CardCode INNER JOIN OUSR T2 ON T0.AttendUser = T2.INTERNAL_K WHERE T0.Action = '[%0]' and T0.AttendUser = '[%1]' GROUP BY T0.ClgCode, T0.Recontact, T0.BeginTime, T0.Action, T2.U_NAME,T1.CardName, T0.Details, T0.CntctCode, T0.Notes
Currently the WHERE clause is giving me errors.
If anyone has an idea of how to make the work it would be appricated.
Thanks,
Craig