MES Stateless API

GetAll Method (DataLogGrpJobLink)

Save PDF

GetAll Method (DataLogGrpJobLink)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAll() method retrieves one or more data log group/job link records from the Data_Log_Grp_Job_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all data log group/job link records from 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 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 certName As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = DataLogGrpJobLink.GetAll(grpId, woId, operId, seqNo, certName, lastEditBy, lastEditAt)

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

Parameters

grpId: Optional filter parameter. Holds the ID of a data log group.
woId: Optional filter parameter. Holds the ID of a job's work order.
operId: Optional filter parameter. Holds the ID of a job's operation.
seqNo: Optional filter parameter. Holds the operation sequence number of a job.
certName: Optional filter parameter. Holds the certification associated with a data log group.
lastEditBy: Optional filter parameter. Holds the user who added or last changed a record.
lastEditAt: Optional filter parameter. Holds the date/time when a record was added or last edited.

Return Value

Returns a DataSet that contains all the records in the Data_Log_Grp_Job_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.

ColumnName	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 work order ID.
oper_id	A string that is the operation ID for the work order.
seq_no	An integer that is the sequence number of this operation.
cert_name	A string that is the certification name linked to this data log group and job.
key_id	An integer value linked to this job and the data log group (grp_desc), from the Data_Entry_Sched table, of data_entry_sched.key type =6 (representing job) and data_entry_sched.category = Datalog Group.
key_type	An integer that identifies the basis of data collection, from the Data_Entry_Sched table.
category	A string that is the category of this data collection group, from the Data_Entry_Sched table.
trigger_type	An integer that identifies the trigger source for this data collection activity, from the Data_Entry_Sched table
trigger_period	An integer that identifies the number of hours or minutes between the data collection triggers, from the Data_Entry_Sched table.
entries_reqd	An integer that is the number of entries required each time this data collection activity is triggered, from the Data_Entry_Sched table.
display_seq	An integer that identifies the display sequence for this data entry requirement to facilitate sorting, from the Data_Entry_Sched table.
string_spare1	A string that contains the spare1 string field contents copied to the data entry log when triggered , from the Data_Entry_Sched table.
string_spare2	A string that contains the spare2 string field contents copied to the data entry log when triggered , from the Data_Entry_Sched table.
string_spare3	A string that contains the spare3 string field contents copied to the data entry log when triggered, from the Data_Entry_Sched table.
string_spare4	A string that contains the spare4 string field contents copied to the data entry log when triggered, from the Data_Entry_Sched table.
number_spare1	An integer that contains the spare1 numeric field copied to the data entry log when triggered, from the Data_Entry_Sched table.
number_spare2	An integer that contains the spare2 numeric field copied to the data entry log when triggered, from the Data_Entry_Sched table.
number_spare3	An integer that contains the spare3 numeric field copied to the data entry log when triggered, from the Data_Entry_Sched table.
number_spare4	An integer that contains the spare4 numeric field copied to the data entry log when triggered, from the Data_Entry_Sched table.
last_edit_comment	A string that contains any comments about why the record was changed.
last_edit_by	A string that is the ID of the user who added or last modified this record.
last_edit_at	A date/time that indicates when the record was added or last modified.
data_entry_sched_last_edit_at	A datetime value that indicates when the record was added or last modified in the Data_Entry_Sched table.

MES Stateless API