Before you dispatch labor or crews, you must create a list
of scheduled work orders and apply a street-level route before dispatching
labor and crew resources.
Procedure
- In the Graphical Assignment application, on the Work
List tab, complete the fields to create a work list.
- Define a work query in the SQL Expression Builder to retrieve
the relevant work and labor or crew records.
For
example, create the following query to find all open work orders that
are scheduled for the next week:
Option |
Description |
DB2® |
((woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0 and schedstart >= CURRENT_TIMESTAMP
and schedstart <= (CURRENT_TIMESTAMP + 7 DAYS) and (status !='COMP'))
|
Microsoft SQL
Server |
((woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0 and schedstart >= GetDate()
and schedstart <= GetDate()+7 and (status !='COMP'))
|
Oracle Database |
((woclass = 'WORKORDER' or woclass = 'ACTIVITY')
and historyflag = 0 and schedstart >= sysdate
and schedstart <= sysdate+7 and (status !='COMP'))
|
- Filter by resources, such as labor and crews.
- Apply the street-level route.