rp_routes::getrouteworkorders

Returns all work orders for route

o.getrouteworkorders( tcRoutes, tdDate, tcTypes, tcFilter, tnResultMode, tcCursor)

Return Value

The number of records found

Parameters

tcRoutes
A comma delimited list of routes for which workorders must be assigned to as
per the service diagram

tdDate
The route date

tcTypes
The work order types to retrieve. Leave blank for all

tcFilter
Any valid filter you want to apply to the query

tnResultMode
This specifies how you want the data returned. For example 1 = XML , 31 = oRows data set

tcCursor
The name of the internal cursor to store the results

Remarks

This method returns a unique list of all work orders assigned to the
specified routes on the specified day. Note that this only returns
work orders at departments for which the auto dispatch flag
is set to true

The structure of the list as per the workordr table

Example

o.GetRouteWorkOrders("535", {08/02/2002},"S","", 31, "Trecords")

The above would;
1.	Retrieve all "S" type work orders assigned to route 535 for the 08/02/2002
2.	Place this list in the internal cursor "TRecords"
3.	Place the list in the collection o.oRows

See also:

Class rp_routes


Last Updated: 23/11/2005