Preparing to dispatch labor and crews

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

  1. In the Graphical Assignment application, on the Work List tab, complete the fields to create a work list.
  2. 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'))
  3. Filter by resources, such as labor and crews.
  4. Apply the street-level route.


Feedback