Work Orders - Notifications

Overview

This Notification displays Work Orders. The Stored Procedure name is NOTIFICATION_WORKORDERS.

Menu Navigation » Office > My Organisation > Staff > Notifications > Work Orders (CPYSTAFF.EMAIL_WO)

Heading

Work Orders - Rep Name - Status - Date - 23 Orders

Fields

• WO No

• SO No

• Date - WO Date

• Rep

• User

• Category

• Customer

• Reference

• Qty

• Status -WO Status - Show Colour

• Location

• Due Date - WO Due Date

SQL for BOS Server (All Work Orders)

select

EMAIL_TO,

EMAIL_CC,

EMAIL_BCC,

SUBJECT,

BODY

from NOTIFICATION_WORKORDERS

(

  :DATEID_IN, --0=No Date Filter, 1=Use Date Filter

  :DATESTART, --Null if No Date Filter

  :DATEEND, --Null if No Date Filter

  :REPID_IN, -- -1=All

  :GROUPID_IN --Status Group - 1=Pending/Active, 2=Complete, -1=All  

)

SQL for BOS Server (Work Orders by Reps)

select

EMAIL_TO,

EMAIL_CC,

EMAIL_BCC,

SUBJECT,

BODY

from NOTIFICATION_WORKORDERS_BYREP

(

  :DATEID_IN, --0=No Date Filter, 1=Use Date Filter

  :DATESTART, --Null if No Date Filter

  :DATEEND, --Null if No Date Filter

  :GROUPID_IN --Status Group - 1=Pending/Active, 2=Complete, -1=All  

)