MES Stateless API

GetAll Method (DataLogGrpStdOperLink)

Save PDF

GetAll Method (DataLogGrpStdOperLink)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

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

Syntax

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

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

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

Parameters

grpId: Optional filter parameter. Holds the ID of a data log group that is being linked.
operId: Optional filter parameter. Holds the ID of an operation that is being linked.
certName: Optional filter parameter. Holds the name of a certification to confirm data.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated a data log group/standard operation link record.
lastEditAt: Optional filter parameter. Holds the date/time when a data log group/standard operation link record was added or last updated.

Return Value

Returns a DataSet that contains records for all the data log group/standard operation link records that satisfy the specified filters. The returned records include columns from the Data_Log_Grp, Data_Entry_Sched, and Data_Log_Grp_Std_Oper_Link tables. If no matching data log group/standard operation link records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
grp_id	An integer that is the ID of the data log group.
grp_desc	A string that is the description of the data log group, from the Data_Log_Grp table.
oper_id	A string that is the ID of the operation to which this data log group is linked.
cert_name	A string that is the name of the certification to confirm data.
key_id	An integer that is the ID of the key or row on which the data collection schedule is based, from the Data_Entry_Sched table. If no data entry schedule exists, all the columns from the Data_Entry_Sched table will have a null value.
key_type	An enumeration that specifies the type of data collection, from the Data_Entry_Sched table. The default value is 2 that represents the job step.
category	A string that is the category of the data collection group, from the Data_Entry_Sched table. The default collection group is "Data log Group".
trigger_type	An integer that is the type of trigger, from the Data_Entry_Sched table. The values for trigger type are 0=shift start, 1=shift end, 2=hourly(future), 3=daily, 4=weekly, 5=minutes, 9=SCC trigger(future).
trigger_period	An integer that is the trigger period which specifies the time interval between data collections, from the Data_Entry_Sched table. The trigger period is valid if trigger_type is 2 (hours) or 5 (minutes), and it represents the number of hours or minutes between collection triggers.
entries_reqd	An integer that is the number of entries required each time the data collection activity is triggered, from the Data_Entry_Sched table.
display_seq	An integer that is the optional sequence of display for the data entry requirement to facilitate sorting, from the Data_Entry_Sched table.
string_spare1	A string that is the contents of the user-defined string_spare1 field.
string_spare2	A string that is the contents of the user-defined string_spare2 field.
string_spare3	A string that is the contents of the user-defined string_spare3 field.
string_spare4	A string that is the contents of the user-defined string_spare4 field.
number_spare1	A number that is the contents of the user-defined number_spare1 field.
number_spare2	A number that is the contents of the user-defined number_spare2 field.
number_spare3	A number that is the contents of the user-defined number_spare3 field.
number_spare4	A number that is the contents of the user-defined number_spare4 field.
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 date/time that indicates when the record was added or last updated.
data_entry_sched_last_edit_at	A date/time that indicates when the Data_Entry_Sched record was added or last updated, from the Data_Entry_Sched table.

MES Stateless API