MES Stateless API

GetAll Method (DataLog16)

Save PDF

GetAll Method (DataLog16)

Save PDF

Last UpdatedNov 06, 2025
5 minute read

The GetAll() method retrieves one or more data log records from the Data_Log table, as specified by the filter parameters. Passing no filter parameters will retrieve all data log records from the table.

Note: The methods in the DataLog16 class should not be used. They have been replaced by the DataLog class methods.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal grpId As Nullable(Of Integer), _
   ByVal sampleTimeUTC As Nullable(Of Date), _
   ByVal sampleTimeLocal As Nullable(Of Date), _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Nullable(Of Integer), _
   ByVal stepNo As Nullable(Of Integer), _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal sublotNo As String, _
   ByVal shiftStartUTC As Nullable(Of Date), _
   ByVal shiftStartLocal As Nullable(Of Date), _
   ByVal shiftId As Nullable(Of Integer), _
   ByVal entId As Nullable(Of Integer), _
   ByVal genealogyId As String, _
   ByVal segmentRequirementId As String, _
   ByVal segmentResponseId As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date), _
   ByVal rowId As Nullable(Of Integer) _
) As DataSet

'Usage
 
Dim grpId As Nullable(Of Integer)
Dim sampleTimeUTC As Nullable(Of Date)
Dim sampleTimeLocal As Nullable(Of Date)
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim stepNo As Nullable(Of Integer)
Dim itemId As String
Dim lotNo As String
Dim sublotNo As String
Dim shiftStartUTC As Nullable(Of Date)
Dim shiftStartLocal As Nullable(Of Date)
Dim shiftId As Nullable(Of Integer)
Dim entId As Nullable(Of Integer)
Dim genealogyId As String
Dim segmentRequirementId As String
Dim segmentResponseId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim value As DataSet
 
value = DataLog16.GetAll(grpId, sampleTimeUTC, sampleTimeLocal, woId, operId, seqNo, stepNo, itemId, lotNo, sublotNo, shiftStartUTC, shiftStartLocal, shiftId, entId, genealogyId, segmentRequirementId, segmentResponseId, lastEditBy, lastEditAt, rowId)

public static DataSet GetAll( 
   Nullable<int> grpId,
   Nullable<DateTime> sampleTimeUTC,
   Nullable<DateTime> sampleTimeLocal,
   string woId,
   string operId,
   Nullable<int> seqNo,
   Nullable<int> stepNo,
   string itemId,
   string lotNo,
   string sublotNo,
   Nullable<DateTime> shiftStartUTC,
   Nullable<DateTime> shiftStartLocal,
   Nullable<int> shiftId,
   Nullable<int> entId,
   string genealogyId,
   string segmentRequirementId,
   string segmentResponseId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt,
   Nullable<int> rowId
)

Parameters

grpId: Optional filter parameter. Holds the DataLogGroup ID.
sampleTimeUTC: Optional filter parameter. Holds the date/time when the sample was first taken, in UTC.
sampleTimeLocal: Optional filter parameter. Holds the date/time when the sample was first taken, in local time.
woId: Optional filter parameter. Holds the ID of work order.
operId: Optional filter parameter. Holds the ID of the operation.
seqNo: Optional filter parameter. Holds the operation sequence number of the job.
stepNo: Optional filter parameter. Holds step number of the job.
itemId: Optional filter parameter. Holds ID of the item to which the data applied.
lotNo: Optional filter parameter. Holds the lot number of the item to which the data applied.
sublotNo: Optional filter parameter. Holds the sublot number of the item to which the data applied
shiftStartUTC: Optional filter parameter. Holds the date/time when the shift started, in UTC.
shiftStartLocal: Optional filter parameter. Holds the date/time when the shift started, in local time.
shiftId: Optional filter parameter. Holds the shift ID.
entId: Optional filter parameter. Holds ID of the entity from which the data came.
genealogyId: Optional filter parameter. Holds the PEM intra-segment genealogy ID.
segmentRequirementId: Optional filter parameter. Holds the S95 segment requirement ID.
segmentResponseId: Optional filter parameter. Holds the S95 segment response ID.
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.
rowId: Optional filter parameter. Holds the unique rowID of the data log record.

Return Value

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

Column Names	Description
grp_id	An integer that is the ID of the DataLogGroup, from the Data_Log table.
grp_desc	A string that is the description of the DataLogGroup, from the Data_Log_Group table.
sample_time	A datetime that indicates when the sample was taken based on the passed-in time zone bias.
sample_time_utc	A datetime that indicates when the sample was taken, in UTC, from the Data_Log table.
sample_time_local	A datetime that indicates when the sample was taken, in local time, from the Data_Log table.
wo_id	A string that is the ID of the work order, from the Data_Log table.
wo_desc	A string that is the description of the work order, from the WO table.
oper_id	A string that is the operation ID, from the Data_Log table.
seq_no	A string that is the sequence number of the operation and identifies the row in the Job table, from the Data_Log table.
job_desc	A string that is the description of the job, from the Job table.
step_no	A string that is the step number and identifies the step within the job, from the Data_Log table.
step_desc	A string that is the step description, from the Job_Step table.
item_id	A string that is the ID of the item to which the data applies, from the Data_Log table.
item_desc	A string that is the item's description, from the Item table.
lot_no	A string that is the lot number of the item to which the data applies, from the Data_Log table.
sublot_no	A string that is the sublot number of the item to which the data applies, from the Data_Log table.
shift_start	A datetime that indicates when the shift started based on the passed in time zone bias.
shift_start_utc	A datetime that indicates when the shift started, in UTC, from the Data_Log table.
shift_start_local	A datetime that indicates when the shift started, in local time, from the Data_Log table.
shift_id	An integer that identifies the shift ID, from the Data_Log table.
shift_desc	A string that is a description of the shift, from the Shift table.
ent_id	An integer that identifies the entity from which the data came, from the Data_Log table.
genealogy_id	A string that identifies the PEM intra-segment genealogy ID, from the Data_Log table.
segment_requirement_id	A string that identifies the S95 segment requirement ID, from the Data_Log table.
segment_response_id	A string that identifies the S95 segment response ID, from the Data_Log table.
value1 to value16	Strings that hold the values logged, from the Data_Log table.
last_edit_comment	A string that contains comments about why the record was added or updated, from the Data_Log table.
last_edit_by	A string that is the ID of the user who added or last updated this record, from the Data_Log table.
last_edit_at	A datetime that indicates when the record was added or last updated, from the Data_Log table.
row_id	An integer that is the unique row identifier for the record.

MES Stateless API