MES Stateless API

GetAll Method (OperEntRoute)

Save PDF

GetAll Method (OperEntRoute)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAll() method retrieves one or more operation/entity route records from the Oper_Ent_Route table, as specified by the filter parameters. Passing no filter parameters will retrieve all operation/entity link records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal processId As String, _
   ByVal operId As String, _
   ByVal entId As Nullable(Of Integer), _
   ByVal inputOperId As String, _
   ByVal inputEntId As Nullable(Of Integer), _
   ByVal inputPercent As Nullable(Of Double), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim processId As String
Dim operId As String
Dim entId As Nullable(Of Integer)
Dim inputOperId As String
Dim inputEntId As Nullable(Of Integer)
Dim inputPercent As Nullable(Of Double)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = OperEntRoute.GetAll(processId, operId, entId, inputOperId, inputEntId, inputPercent, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string processId,
   string operId,
   Nullable<int> entId,
   string inputOperId,
   Nullable<int> inputEntId,
   Nullable<double> inputPercent,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

processId: Optional filter parameter. Holds the ID of the process for which the operation routes are being retrieved.
operId: Optional filter parameter. Holds the ID of the operation whose routes are being retrieved.
entId: Optional filter parameter. Holds the ID of the entity on which the operation is being performed.
inputOperId: Optional filter parameter. Holds the ID of the predecessor operation.
inputEntId: Optional filter parameter. Holds the ID of the predecessor entity.
inputPercent: Optional filter parameter. Holds the percentage of how much of the predecessor's production comes to this operation.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated the link record.
lastEditAt: Optional filter parameter. Holds a date/time when the record was added or last edited.

Return Value

Returns a DataSet that contains the operation/entity route records in the Oper_Ent_Route table that satisfy the specified filters. If no matching records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
process_id	A string that is the ID of the process for which the operation route is defined.
oper_id	A string that is the ID of the operation for this process.
ent_id	An integer that is the ID of the entity on which the operation is run.
input_oper_id	A string that is the predecessor operation.
input_ent_id	An integer that is the ID of the entity on which the predecessor operation ran.
process_desc	A string that is a description of this process version, from the Process table.
ent_name	A string that is the name of the entity on which this operation is run, from the Ent table.
input_ent_name	A string that is the name of the entity on which the predecessor operation ran, from the Ent table.
input_percent	A floating point number that is the percentage of the predecessor’s production that comes here. The default = 100% = 1.00.
last_edit_comment	A string that contains comments about why the record was changed.
last_edit_by	A string that is the ID of the user who added or last updated this record.
last_edit_at	A datetime that is the date/time when the record was added or last updated.
mod_id	The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes.

MES Stateless API