Clock
Clock
Breadcrumbs

Updating the jxJobServiceCall View to Only Display Job Name for the Description

To edit what your users see in the Clock Time Entry or Expense Activity drop-down list for the Job Description, you will need to edit the jxJobServiceCall view (Job UNION query only). In the table below, the left column is the standard jxJobServiceCall view with the red bolded text indicating what needs to be removed. The right column's bolded text shows what the modified jxJobServiceCall view should look like to only return JC00102.WS_Job_Name as the Description.

Standard jxJobServiceCall View (Job UNION query only)

Modified jxJobServiceCall View

    SELECT 
        'JC - ' + RTRIM(JC00102.WS_Job_Number) AS 'Name',
        ISNULL(RTRIM(SV00200.LOCATNNM),JC00102.WS_Job_Name) AS 'Description',
        'All Jobs, Job Cost Jobs' AS 'Group',
        RTRIM(JC00102.CUSTNMBR) AS 'Customer Number',
        RTRIM(JC00102.Job_Address_Code) AS 'Location Number',
        RTRIM(JC00102.WS_Job_Number) AS 'Job Number',
        '1900-01-01 00:00:00' AS 'Date of Call',
        RTRIM(JC00102.WS_Manager_ID) AS 'Project Manager',
        0 AS 'Account Index',
        'JOB COST' AS 'TrxType',
        RTRIM(JC00102.WS_Job_Number) AS 'GP ID'
    FROM JC00102
    LEFT OUTER JOIN SV00200
      ON SV00200.CUSTNMBR = JC00102.CUSTNMBR
     AND SV00200.ADRSCODE = JC00102.Job_Address_Code
    WHERE JC00102.WS_Inactive = 0

    SELECT 
        'JC - ' + RTRIM(JC00102.WS_Job_Number) AS 'Name',
        RTRIM(JC00102.WS_Job_Name) AS 'Description',
        'All Jobs, Job Cost Jobs' AS 'Group',
        RTRIM(JC00102.CUSTNMBR) AS 'Customer Number',
        RTRIM(JC00102.Job_Address_Code) AS 'Location Number',
        RTRIM(JC00102.WS_Job_Number) AS 'Job Number',
        '1900-01-01 00:00:00' AS 'Date of Call',
        RTRIM(JC00102.WS_Manager_ID) AS 'Project Manager',
        0 AS 'Account Index',
        'JOB COST' AS 'TrxType',
        RTRIM(JC00102.WS_Job_Number) AS 'GP ID'
    FROM JC00102
    LEFT OUTER JOIN SV00200
      ON SV00200.CUSTNMBR = JC00102.CUSTNMBR
     AND SV00200.ADRSCODE = JC00102.Job_Address_Code
    WHERE JC00102.WS_Inactive = 0