GetAll Method (JobHistory)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAll() method retrieves one or more job history records from the Job_History table, as specified by the filter parameters.
'Declaration
Public Shared Function GetAll( _
ByVal entityId As Nullable(Of Integer), _
ByVal jobPos As Nullable(Of Integer), _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal itemId As String, _
ByVal jobStartUtc As Nullable(Of Date), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim entityId As Nullable(Of Integer)
Dim jobPos As Nullable(Of Integer)
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim itemId As String
Dim jobStartUtc As Nullable(Of Date)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = JobHistory.GetAll(entityId, jobPos, woId, operId, seqNo, itemId, jobStartUtc, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> entityId,
Nullable<int> jobPos,
string woId,
string operId,
Nullable<int> seqNo,
string itemId,
Nullable<DateTime> jobStartUtc,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- entityId
- Optional. Holds the entity ID of the job.
- jobPos
- Optional. Holds the position of the job.
- woId
- Optional. Holds the work order ID of the job.
- operId
- Optional. Holds the operation ID of the job.
- seqNo
- Optional. Holds the sequence number of the job.
- itemId
- Optional. Holds the item ID of the job.
- jobStartUtc
- Optional. Holds the start date/time of the job, in UTC.
- lastEditBy
- Optional. Holds the name of the user who added or last changed an entity record.
- lastEditAt
- Optional. Holds a date/time of when a job history record was added or last changed.
Return Value
Returns a DataSet that contains a DataRow for each job history record that satisfies the specified filter criteria from the Job_History table. If no matching record is found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
log_id |
An integer that is the log ID of the utilization event that started immediately prior to the start of the job. This column is used for backward compatibility for versions of MES prior to version 6.0. It is not used in version 6.0 or later versions. |
|
wo_id |
A string that is the work order ID of the job. |
|
oper_id |
A string that is the operation ID of the job. |
|
seq_no |
An integer that is the sequence number of the job. |
|
item_id |
A string that is the ID of the item that is produced by the job. |
|
job_start_utc |
A datetime that is the start time of the job in UTC. |
|
job_start_local |
A datetime that is the start time of the job in the entity's local time. |
|
duration |
An integer that is the duration of the job, in seconds. This column is used for backward compatibility for versions of MES prior to version 6.0. It is not used in version 6.0 or later versions. |
|
job_start |
A datetime that is the start time of the job in the client's local time. |
|
job_end |
A datetime that is the end time of the job in the client's local time. |
|
spare1 |
A string that holds the content of the user-defined spare1 field. |
|
spare2 |
A string that holds the content of the user-defined spare2 field. |
|
spare3 |
A string that holds the content of the user-defined spare3 field. |
|
spare4 |
A string that holds the content of the user-defined spare4 field. |
|
last_edit_comment |
A string that contains comments about why the record was added or last changed. |
|
last_edit_by |
A string that holds the user who last edited this record. |
|
last_edit_at |
A datetime that identifies when the record was added or last modified. |
|
row_id |
An integer that is a unique identifier for the record. |
|
ent_id |
An integer that is the ID of the entity on which job is executed. |
|
job_end_utc |
A datetime that is the end time of the job in UTC. |
|
job_end_local |
A datetime that is the end time of the job in the entity's local time. |