MES Stateless API

GetAll Method (OperEntLink)

Save PDF

GetAll Method (OperEntLink)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAll() method retrieves one or more operation/entity link records from the Oper_Ent_Link 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 parentContingentEnt As Nullable(Of Boolean), _
   ByVal childContingentEnt As Nullable(Of Boolean), _
   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 parentContingentEnt As Nullable(Of Boolean)
Dim childContingentEnt As Nullable(Of Boolean)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = OperEntLink.GetAll(processId, operId, entId, parentContingentEnt, childContingentEnt, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string processId,
   string operId,
   Nullable<int> entId,
   Nullable<bool> parentContingentEnt,
   Nullable<bool> childContingentEnt,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

processId: Optional filter parameter. Holds the ID of the process that contains the operation whose entity link records are being retrieved.
operId: Optional filter parameter. Holds the ID of the operation whose entity link records are being retrieved.
entId: Optional filter parameter. Holds the ID of the entity whose operation link records are being retrieved.
parentContingentEnt: Optional filter parameter. Holds a flag that specifies whether a link is for a group that will really be run on one or more child entities.
childContingentEnt: Optional filter parameter. Holds a flag that specifies whether a link is potentially for one of a group of entities.
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 link records in the Oper_Ent_Link 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 process ID, from the Oper_Ent_Link table
oper_id	A string that is the operation ID, from the Oper_Ent_Link table
ent_id	An integer that is the entity ID, from the Oper_Ent_Link table.
ent_name	A string that is the name of the entity, from the Ent table.
process_desc	A string that is the process description, from the Process table
est_fixed_lab	A floating point number that is the estimated fixed labor setup/cleanup hours, from the Oper_Ent_Link table
est_lab_rate	A floating point number that is the estimated variable labor batch time, depending on prod_uom. 0 (default) or 3 = hours/batch, 1 or 4 = minutes/batch, 2 or 5 = seconds/batch from the Oper_Ent_Link table
est_setup_time	A floating point number that is the estimated entity hours for setup, from the Oper_Ent_Link table
est_teardown_time	A floating point number that is the estimated entity hours for teardown, from the Oper_Ent_Link table
est_prod_rate	A floating point number that is the estimated entity batch rate or time, depending on prod_uom, from the Oper_Ent_Link table. 0 = hours/batch (default) 1 = minutes/batch 2 = seconds/batch 3 = batches/hour 4 = batches/minute 5 = batches/second
prod_uom	An integer that is the unit of measure for est_lab_rate, from the Oper_Ent_Link table
batch_size	A floating point number that is the batch size of the entity (default=1), from the Oper_Ent_Link table.
est_transfer_time	A floating point number that is the transfer time after operation – hours, from the Oper_Ent_Link table
init_prod_pct	A floating point number that is the initial production percent required at this entity (if the first operation is done at multiple entities), or null for other cases, from the Oper_Ent_Link table.
parent_contingent_ent	A Boolean that is a flag that indicates whether the link is for a group that will really be run on one or more children, from the Oper_Ent_Link table. The default is false.
child_contingent_ent	A Boolean that is a flag that indicates whether the link is potentially for one of a group of entities, from the Oper_Ent_Link table. The default is false.
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 specifies 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