MES Stateless API

GetAll Method (DataLogGrpJobStepLink)

Save PDF

GetAll Method (DataLogGrpJobStepLink)

Save PDF

Last UpdatedNov 06, 2025
4 minute read

The GetAll() method retrieves one or more data log group/job step link records in the Data_Log_Grp_Job_Step_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all data log group/job step link records in the table.

Syntax

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

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

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

Parameters

grpId: Optional filter parameter. Holds the ID of the data log group that is being linked.
woId: Optional filter parameter. Holds the work order ID of the job step that is being linked.
operId: Optional filter parameter. Holds the operation ID of the job step that is being linked.
seqNo: Optional filter parameter. Holds the operation sequence number of the job step that is being linked.
stepNo: Optional filter parameter. Holds the step number of the job step that is being linked.
certName: Optional filter parameter. Holds the certification necessary to confirm data.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated this record.
lastEditAt: Optional filter parameter. Holds the date/time when this 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.
wo_id	A string that is the ID of the work order of the job.
oper_id	A string that is the ID of the operation of the job.
seq_no	An integer that is the sequence number of the job.
step_no	An integer that is the number of the step linked to the data log group.
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.
row_id	An integer that is the ID of the row in the Data_Log_Grp_Job_Step_Link table.

MES Stateless API