MES Stateless API

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,Nullable<DateTime>,Nullable<Boolean>) Method

Save PDF

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,Nullable<DateTime>,Nullable<Boolean>) Method

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAll() method retrieves the OEE exec records of one or more entities from the Oee_Exec table, as specified by the filter parameters. Passing no filter parameters will retrieve all OEE exec records from the table.

This overload of the method includes the getCurrentOee parameter.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal entId As Nullable(Of Integer), _
   ByVal jobEntId As Nullable(Of Integer), _
   ByVal utilEntId As Nullable(Of Integer), _
   ByVal basis As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date), _
   ByVal getCurrentOee As Nullable(Of Boolean) _
) As DataSet

'Usage
 
Dim entId As Nullable(Of Integer)
Dim jobEntId As Nullable(Of Integer)
Dim utilEntId As Nullable(Of Integer)
Dim basis As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim getCurrentOee As Nullable(Of Boolean)
Dim value As DataSet
 
value = OeeExec.GetAll(entId, jobEntId, utilEntId, basis, lastEditBy, lastEditAt, getCurrentOee)

public static DataSet GetAll( 
   Nullable<int> entId,
   Nullable<int> jobEntId,
   Nullable<int> utilEntId,
   Nullable<int> basis,
   string lastEditBy,
   Nullable<DateTime> lastEditAt,
   Nullable<bool> getCurrentOee
)

Parameters

entId

Optional filter parameter. Holds the ID of an entity whose OEE exec records are being retrieved.

jobEntId

Optional filter parameter. Holds the ID of an entity from which production data is obtained for the entities whose OEE exec records are being retrieved.

utilEntId

Optional filter parameter. Holds the ID of an entity from which utilization data is obtained for the entities whose OEE exec records are being retrieved.

basis

Optional filter parameter. Holds an integer that is used to indicate how OEE is displayed for the entities whose OEE exec records are being retrieved.

0 = OEE displayed by shift (default)

1 = OEE displayed by job

lastEditBy

Optional filter parameter. Holds the ID of the user who added or last updated the record.

lastEditAt

Optional filter parameter. Holds the date/time when the record was added or last updated.

getCurrentOee

Optional filter parameter. Holds a flag that, if set to false, specifies that the system will not be triggered to recalculate the current OEE value. Defaults to true.

Return Value

Returns a DataSet that contains records for all the OEE execs that satisfy the specified filters. The returned records include columns from the OEE_Exec and Ent tables. If no matching OEE execs are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Names	Description
ent_id	An integer that is the entity ID, from the Oee_Exec table.
ent_name	A string that is the entity name, from the Ent table.
job_ent_id	An integer that is the job entity ID, from the Oee_Exec table.
job_ent_name	A string that is the job entity name, from the Ent table.
util_ent_id	An integer that is the utilization entity ID, from the Oee_Exec table.
util_ent_name	A string that is the utilization entity name, from the Ent table.
target_perf	A double-precision floating point number that is the target performance value, from the Oee_Exec table.
current_perf	A double-precision floating point number that is the current performance value, from the Oee_Exec table.
target_qual	A double-precision floating point number that is the target quality value, from the Oee_Exec table.
current_qual	A double-precision floating point number that is the current quality value, from the Oee_Exec table.
def_prod_rate	A double-precision floating point number that is the default production rate, from the Oee_Exec table.
prod_uom	An integer that is the production UOM, from the Oee_Exec table.
batch_size	A double-precision floating point number that identifies the standard batch size for reporting production rate, from the Oee_Exec table.
std_item_id	A string that is the ID of the standard item to use for reporting production rate, from the Oee_Exec table.
target_oee	A double-precision floating point number that is the target OEE, from the Oee_Exec table.
current_oee	A double-precision floating point number that is the current OEE, from the Oee_Exec table.
basis	An integer that indicates how OEE is displayed for the entity [0=OEE displayed by shift (default); 1=OEE displayed by job], from the Oee_Exec table.
last_edit_comment	A string that contains comments about why the record was updated, from the Oee_Exec table.
last_edit_by	A string that is the ID of the user who added or last updated this record, from the Oee_Exec table.
last_edit_at	A datetime that indicates when the record was added or last updated, from the Oee_Exec table.

MES Stateless API