There are only Call activity codes shown in the Query builder for appointments, how do I add other activity codes?

Version 1

    Details

    There are only Call activity codes shown in the Query builder for appointments, how do I add other activity codes?


    Resolution

    The query builder does not include every activity code by default for all of the possible activities.  The Call Activity codes are provide as an example of what can be done.   If you would like to use activity codes not listed you will need to manually while building the SQL statement.

    Using the example SQL statement below, you would change the Value 'CFU' to your activity code and then query for the appointments desired.

    SELECT  CL.*  FROM  GOLDMINE2013.DBO.CAL CL WHERE (CL.RECTYPE in ('A')) AND (CL.ACTVCODE = 'CFU')