Skip to Content
0
Former Member
Jun 04, 2008 at 12:39 PM

Activity Query

52 Views

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