Work Orders - Notifications

Overview#

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

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
)