MES Stateless API

GetAll Method (StagingTypeConfig)

Save PDF

GetAll Method (StagingTypeConfig)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAll() method retrieves one or more staging type configuration records from the Staging_Type_Config table, as specified by the filter parameters. Passing no filter parameters will retrieve all type configuration records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal stagingTypeId As String, _
   ByVal mesTableName As String, _
   ByVal isReferenceType As Nullable(Of Boolean), _
   ByVal isGlobal As Nullable(Of Boolean), _
   ByVal isEnabled As Nullable(Of Boolean), _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim stagingTypeId As String
Dim mesTableName As String
Dim isReferenceType As Nullable(Of Boolean)
Dim isGlobal As Nullable(Of Boolean)
Dim isEnabled As Nullable(Of Boolean)
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = StagingTypeConfig.GetAll(stagingTypeId, mesTableName, isReferenceType, isGlobal, isEnabled, lastEditAt)

public static DataSet GetAll( 
   string stagingTypeId,
   string mesTableName,
   Nullable<bool> isReferenceType,
   Nullable<bool> isGlobal,
   Nullable<bool> isEnabled,
   Nullable<DateTime> lastEditAt
)

Parameters

stagingTypeId: Optional filter parameter. Holds the ID of a CONNECT data services type.
mesTableName: Optional filter parameter. Holds a MES table name.
isReferenceType: Optional filter parameter. Holds a flag that specifies whether the staging type is reference type or not.False means it is event.
isGlobal: Optional filter parameter. Holds a flag that specifies whether the data for this type is global across sites.
isEnabled: Optional filter parameter. Indicates whether the data type requires curation.
lastEditAt: Optional filter parameter. Holds the date time when a staging type configuration record was added or last changed.

Return Value

Returns a DataSet that contains records for all the CONNECT data services type configurations that satisfy the specified filters. The returned records include columns from the Staging_Type_Config table. If no types are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
staging_type_id	Identifies the type of curated event. For example, MESEquipmenUtilizationHistory.
mes_table_name	The staging type that is mapped to a table in MES. For example, Asset in CONNECT is mapped to Ent in MES.
type_description	Description of this staging type.
curate_frequency	Identifies the frequency (in minutes) in which the data will be curated. 0, if the data is curated on demand for this type. >=5 when the data is curated and staged.
is_reference_type	Identifies whether this is a reference type. If false, then it is an event.
is_global	Determines whether the data for this type is global across sites.
is_enabled	Determines whether this data type requires curation or not. True, when the curation is allowed for this type; otherwise, false.
processing_order	Determines the order in which the reference data and events data are curated.
last_edit_comment	A string that contains comments about why the record was added or changed.
last_edit_by	A string that is the ID of the user who added or last updated this record.
last_edit_at	A date time that indicates when the record was added or last updated.
row_id	A unique row identifier.

MES Stateless API