GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<DateTime>,Nullable<DateTime>,String,String,Nullable<Int32>,Nullable<Int32>,String,String,String,Nullable<Int32>,Nullable<DateTime>,Nullable<DateTime>,String,String,String,String,Nullable<DateTime>,Nullable<DateTime>,Nullable<Int64>) Method
- 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. This overload filters the row_id as a long integer, does not have createdAtLocal, and is the preferred method to use.
'Declaration
Public Overloads Shared Function GetAll( _
ByVal grpId As Nullable(Of Integer), _
ByVal entId 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 shiftId As Nullable(Of Integer), _
ByVal shiftStartUTC As Nullable(Of Date), _
ByVal shiftStartLocal As Nullable(Of Date), _
ByVal genealogyId As String, _
ByVal segmentRequirementId As String, _
ByVal segmentResponseId As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal createdAtUTC As Nullable(Of Date), _
ByVal rowId As Nullable(Of Long) _
) As DataSet
'Usage
Dim grpId As Nullable(Of Integer)
Dim entId 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 shiftId As Nullable(Of Integer)
Dim shiftStartUTC As Nullable(Of Date)
Dim shiftStartLocal As Nullable(Of Date)
Dim genealogyId As String
Dim segmentRequirementId As String
Dim segmentResponseId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim createdAtUTC As Nullable(Of Date)
Dim rowId As Nullable(Of Long)
Dim value As DataSet
value = DataLog.GetAll(grpId, entId, sampleTimeUTC, sampleTimeLocal, woId, operId, seqNo, stepNo, itemId, lotNo, sublotNo, shiftId, shiftStartUTC, shiftStartLocal, genealogyId, segmentRequirementId, segmentResponseId, lastEditBy, lastEditAt, createdAtUTC, rowId)
public static DataSet GetAll(
Nullable<int> grpId,
Nullable<int> entId,
Nullable<DateTime> sampleTimeUTC,
Nullable<DateTime> sampleTimeLocal,
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> stepNo,
string itemId,
string lotNo,
string sublotNo,
Nullable<int> shiftId,
Nullable<DateTime> shiftStartUTC,
Nullable<DateTime> shiftStartLocal,
string genealogyId,
string segmentRequirementId,
string segmentResponseId,
string lastEditBy,
Nullable<DateTime> lastEditAt,
Nullable<DateTime> createdAtUTC,
Nullable<long> rowId
)
Parameters
- grpId
- Optional filter parameter. Holds the ID of the data log group.
- entId
- Optional filter parameter. Holds the ID of the entity from which the data came.
- sampleTimeUTC
- Optional filter parameter. Holds the date and time when the sample was first taken, in UTC.
- sampleTimeLocal
- Optional filter parameter. Holds the date and time when the sample was first taken, in the entity's local time.
- woId
- Optional filter parameter. Holds the ID of the 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 the step number of the job.
- itemId
- Optional filter parameter. Holds the 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.
- shiftId
- Optional filter parameter. Holds the shift ID.
- shiftStartUTC
- Optional filter parameter. Holds the date and time when the shift started, in UTC.
- shiftStartLocal
- Optional filter parameter. Holds the date and time when the shift started, in the entity's local time.
- 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 the record.
- lastEditAt
- Optional filter parameter. Holds the date and time when the record was added or last edited.
- createdAtUTC
- Optional filter parameter. Holds the date and time when the data log was created, in UTC.
- rowId
- Optional filter parameter. Holds the unique row ID 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 values come from the Data_Log table unless otherwise noted.
| Column Names | Description |
|---|---|
| grp_id | An integer that is the ID of the data log group. |
| ent_id | An integer that is the ID of the entity from which the data came. |
| sample_time_utc | A datetime that indicates when the sample was first taken, in UTC. |
| sample_time_local | A datetime that indicates when the sample was first taken, in the entity's local time. |
| sample_time | A datetime that indicates when the sample was first taken, in the local time of the client application that is making the call. |
| wo_id | A string that is the ID of the work order. |
| 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. |
| seq_no | A string that is the operation sequence number of the job. |
| 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. |
| 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. |
| 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. |
| sublot_no | A string that is the sublot number of the item to which the data applies. |
| shift_id | An integer that is the shift ID. |
| shift_start_utc | A datetime that indicates when the shift started, in UTC. |
| shift_start_local | A datetime that indicates when the shift started, in the entity's local time. |
| shift_start | A datetime that indicates when the shift started, in the local time of the client application that is making the call. |
| genealogy_id | A string that is the PEM intra-segment genealogy ID. |
| segment_requirement_id | A string that is the S95 segment requirement ID. |
| segment_response_id | A string that is the S95 segment response ID. |
| value1 to value64 | Strings that hold the values logged. |
| 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 datetime that indicates when the record was added or last updated. |
| created_at_utc | A datetime that indicates when the data log was created, in UTC. |
| row_id | An long integer value that is the unique row identifier for the record. |