GetAll Method (JobEvent)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal rowId As Nullable(Of Integer), _
ByVal eventTimeUtc As Nullable(Of Date), _
ByVal eventTimeLocal 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 eventType As String, _
ByVal entId As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim rowId As Nullable(Of Integer)
Dim eventTimeUtc As Nullable(Of Date)
Dim eventTimeLocal 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 eventType As String
Dim entId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = JobEvent.GetAll(rowId, eventTimeUtc, eventTimeLocal, woId, operId, seqNo, stepNo, eventType, entId, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> rowId,
Nullable<DateTime> eventTimeUtc,
Nullable<DateTime> eventTimeLocal,
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> stepNo,
string eventType,
Nullable<int> entId,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- rowId
- Optional filter parameter. Holds the row ID of the job event record in the Job_Event table to be retrieved.
- eventTimeUtc
- Optional filter parameter. Holds the date/time that the job event occurred, in UTC time.
- eventTimeLocal
- Optional filter parameter. Holds the date/time that the job event occurred, in local time.
- woId
- Optional filter parameter. Holds the ID of the work order for a job.
- operId
- Optional filter parameter. Holds the ID of the operation for a job.
- seqNo
- Optional filter parameter. Holds the sequence number for a operation.
- stepNo
- Optional filter parameter. Holds the job step for an event.
- eventType
- Optional filter parameter. Holds the event type used to categorize a job event.
- entId
- Optional filter parameter. Holds the ID of the entity related to a job event.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who added or last updated this type of record.
- lastEditAt
- Optional filter parameter. Holds a date/time when this type of record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Job_Event 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 Name |
Description |
|---|---|
|
row_id |
An integer that is the unique identifier for the row. |
|
event_time_utc |
A datetime that is the job event UTC time. |
|
event_time_local |
A datetime that is the job event local time. |
|
event_time |
A datetime that is the job event time in the client’s local time. |
|
wo_id |
A string that is the ID of the work order for the job. |
|
oper_id |
A string that is the ID of the operation for the job. |
|
seq_no |
An integer that is the sequence number for the job. |
|
step_no |
An integer that is the job step number |
|
event_type |
A string that is the category of job event. |
|
ent_id |
An integer that is the ID of the entity related to this job event. |
|
bom_pos |
An integer that is the BOM position related to this job event. |
|
lot_no |
A string that is the lot number related to this job event. |
|
item_id |
A string that is ID of the item related to this job event. |
|
cert_name |
A string that is certification name related to this job event. |
|
done_by_user_id |
A string that is ID of the user who has performed an action for this job event. |
|
checked_by_user_id |
A string that is ID of the user who has checked an action for this job event. |
|
source_row_id |
An integer that is the ID of the row in the Item_Prod or Item_Cons table to which this job event relates. |
|
spec_id |
A string that is the ID of the specification to which this job event relates. |
|
comments |
A string that is a comment for this event. |
|
value1-10 |
A string that is value 1 to value 10 for the spare field values. |
|
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. |