GetByFilter(Nullable<Int32>,Nullable<DateTime>,Nullable<DateTime>,String,String,Nullable<Int32>,Nullable<Int32>,String,String,Nullable<Int32>,Nullable<DateTime>,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 4 minute read
The GetByFilter() method retrieves a set of data log records based on the input filters.
In this overload of the method, the data log group filter is identified by its group ID.
'Declaration
Public Overloads Shared Function GetByFilter( _
ByVal grpId As Nullable(Of Integer), _
ByVal sampleTimeStart As Nullable(Of Date), _
ByVal sampleTimeEnd 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 shiftId As Nullable(Of Integer), _
ByVal shiftStart As Nullable(Of Date), _
ByVal shiftEnd As Nullable(Of Date) _
) As DataSet
'Usage
Dim grpId As Nullable(Of Integer)
Dim sampleTimeStart As Nullable(Of Date)
Dim sampleTimeEnd 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 shiftId As Nullable(Of Integer)
Dim shiftStart As Nullable(Of Date)
Dim shiftEnd As Nullable(Of Date)
Dim value As DataSet
value = DataLogGrp.GetByFilter(grpId, sampleTimeStart, sampleTimeEnd, woId, operId, seqNo, stepNo, itemId, lotNo, shiftId, shiftStart, shiftEnd)
public static DataSet GetByFilter(
Nullable<int> grpId,
Nullable<DateTime> sampleTimeStart,
Nullable<DateTime> sampleTimeEnd,
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> stepNo,
string itemId,
string lotNo,
Nullable<int> shiftId,
Nullable<DateTime> shiftStart,
Nullable<DateTime> shiftEnd
)
Parameters
- grpId
- Optional filter parameter. Holds the ID of a data log group.
- sampleTimeStart
- Optional filter parameter. Holds the start time of a sample collection.
- sampleTimeEnd
- Optional filter parameter. Holds the end time of a sample collection.
- woId
- Optional filter parameter. Holds the work order ID of a job.
- operId
- Optional filter parameter. Holds the operation ID of a job.
- seqNo
- Optional filter parameter. Holds the operation sequence number of a job.
- stepNo
- Optional filter parameter. Holds the step number associated to a job.
- itemId
- Optional filter parameter. Holds the ID of an item of a job.
- lotNo
- Optional filter parameter. Holds the lot number to which data was applied.
- shiftId
- Optional filter parameter. Holds the ID of a shift on which the data was collected.
- shiftStart
- Optional filter parameter. Holds the start time of a shift on which data was collected.
- shiftEnd
- Optional filter parameter. Holds the end time of a shift on which data was collected.
Return Value
Returns a DataSet that contains records from 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 data log group. |
| 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. |
| wo_id | A string that is the ID of the work order. |
| oper_id | A string that is the operation ID. |
| seq_no | A string that is the operation sequence number of the job. |
| step_no | A string that is the step number and identifies the step within the job. |
| item_id | A string that is the ID of the item to which the data applies. |
| lot_no | A string that is the lot number of the item to which the data applies. |
| 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_id | An integer that is the shift ID. |
| ent_id | An integer that is the ID of the entity from which the data came. |
| 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 are the values for the value1 to value64 columns. |
| item_desc | A string that is the item's description, from the Item table. |
| grp_desc | A string that is the description of the data log group. |
| ent_name | A string that is the name of the entity from which the data came. |
| last_edit_at | A datetime that indicates when the record was added or last updated. |
| row_id | An integer that is the unique row identifier for the record. |
| created_at_utc | A datetime that indicates when the data log record was created, in UTC. |
| created_at_local | A datetime that indicates when the data log record was created, in the entity's local time. |
| created_at | A datetime that indicates when the data log record was created, in the local time of the client application that is making the call. |