MES Stateless API

GetJobRoute Method

Save PDF

GetJobRoute Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetJobRoute() method retrieves a list of jobs for the specified work order, in the order in which they are defined to be displayed on the job route diagram.

Syntax

'Declaration
 
Public Shared Function GetJobRoute( _
   ByVal woId As String _
) As DataSet

'Usage
 
Dim woId As String
Dim value As DataSet
 
value = JobRoute.GetJobRoute(woId)

public static DataSet GetJobRoute( 
   string woId
)

Parameters

woId: Required. Holds the work order ID of the jobs that are being retrieved.

Return Value

Returns a DataSet that contains all the the job records in the Job table for the specified work order, in the order in which they are defined to be displayed on the job route diagram. If no matching records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
wo_id	A string that is the work order ID of the job.
oper_id	A string that is the operation ID of the job.
seq_no	An integer that is the operation sequence number of the job.
run_ent_id	An integer that is the ID of the entity on which the job is actually run. The value is null if the job has not been started yet.
run_ent_name	A string that is the name of the entity on which the job is actually run, from the Ent table. The value is null if the job has not been started yet.
qty_prod	A double that is the quantity of the item made so far. The default is 0.
qty_reqd	A double that is the quantity of the item that is required.
target_sched_ent_id	An integer that is the ID of the entity to which the job is actually scheduled.
target_sched_ent_name	A string that is the name of the entity to which the job is actually scheduled, from the Ent table.
state_cd	An integer that is the current job state of the job. The default = 1 for New.
color	An integer that represents the RGB background color used to represent a job state, from the Job_State table.
display_seq	An integer that specifies the sequence of jobs independently of oper_id. It is used to sequence jobs in a tree or flow diagram.

MES Stateless API

GetJobRoute Method

Table of Contents

GetJobRoute Method

In This Topic

MES Stateless API

GetJobRoute Method

Syntax

Parameters

Return Value

See Also

Reference

In This Topic