MES Stateless API

GetAll Method (StdOperEntLink)

Save PDF

GetAll Method (StdOperEntLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

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

'Usage
 
Dim operId As String
Dim entId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = StdOperEntLink.GetAll(operId, entId, lastEditBy, lastEditAt)

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

Parameters

operId: Optional filter parameter. Holds the ID of an operation whose entity links are being retrieved.
entId: Optional filter parameter. Holds the ID of an entity whose operation links are being retrieved.
lastEditBy: Optional filter parameter. Holds the ID of a user who added or last updated a standard operation/entity link record.
lastEditAt: Optional filter parameter. Holds the date/time when a standard operation/entity link record was added or last updated.

Return Value

Returns a DataSet that contains all the records in the Std_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
oper_id	A string that is the ID of the operation.
ent_id	An integer that is the ID of the entity.
ent_name	A string value that is the entity name, from the Ent table linked to the ent_id.
est_fixed_lab	A double that is the estimated fixed labor hours.
est_lab_rate	A double that is the estimated variable labor batch time depending on prod_uom.
est_setup_time	A double that is the estimated entity hours for setup.
est_teardown_time	A double that is the estimated entity hours for teardown.
est_prod_rate	A double that is the estimated entity batch rate or time, depending on prod_uom.
prod_uom	An integer that is the unit of measure for est_lab_rate and est_prod_rate.
batch_size	A double that is the size of the batch.
est_transfer_time	A double that is the transfer time after operation in hours.
init_prod_pct	A double that is the initial production % required at this entity.
last_edit_comment	A string that contains comments about why the record was added or updated.
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 indicates when the record was added or last updated.

MES Stateless API