GetAll Method (JobStepData)
- Last UpdatedNov 06, 2025
- 5 minute read
The GetAll() method retrieves one or more job step data records from the Job_Step_Data table, as specified by the filter parameters. Passing no filter parameters will retrieve all job step data records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal stepNo As Nullable(Of Integer), _
ByVal lotNumber As String, _
ByVal subLotNumber As String, _
ByVal stateCd As Nullable(Of Integer), _
ByVal actStartTimeUtc As Nullable(Of Date), _
ByVal actFinishTimeUtc As Nullable(Of Date), _
ByVal startUserId As String, _
ByVal finishUserId As String, _
ByVal dataUserId As String, _
ByVal formDone As Nullable(Of Boolean), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal spare5 As String, _
ByVal spare6 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal rowId As Nullable(Of Integer) _
) As DataSet
'Usage
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim stepNo As Nullable(Of Integer)
Dim lotNumber As String
Dim subLotNumber As String
Dim stateCd As Nullable(Of Integer)
Dim actStartTimeUtc As Nullable(Of Date)
Dim actFinishTimeUtc As Nullable(Of Date)
Dim startUserId As String
Dim finishUserId As String
Dim dataUserId As String
Dim formDone As Nullable(Of Boolean)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim spare5 As String
Dim spare6 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim value As DataSet
value = JobStepData.GetAll(woId, operId, seqNo, stepNo, lotNumber, subLotNumber, stateCd, actStartTimeUtc, actFinishTimeUtc, startUserId, finishUserId, dataUserId, formDone, spare1, spare2, spare3, spare4, spare5, spare6, lastEditBy, lastEditAt, rowId)
public static DataSet GetAll(
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> stepNo,
string lotNumber,
string subLotNumber,
Nullable<int> stateCd,
Nullable<DateTime> actStartTimeUtc,
Nullable<DateTime> actFinishTimeUtc,
string startUserId,
string finishUserId,
string dataUserId,
Nullable<bool> formDone,
string spare1,
string spare2,
string spare3,
string spare4,
string spare5,
string spare6,
string lastEditBy,
Nullable<DateTime> lastEditAt,
Nullable<int> rowId
)
Parameters
- 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 job step number.
- lotNumber
- Optional filter parameter. Holds the lot number of the item that results from the job.
- subLotNumber
- Optional filter parameter. Holds the sublot number of the item that results from the job.
- stateCd
- Optional filter parameter. Holds the JobStateCode enumeration that indicates the step state.
- actStartTimeUtc
- Optional filter parameter. Holds the UTC time the step was started.
- actFinishTimeUtc
- Optional filter parameter. Holds the UTC time the step was finished.
- startUserId
- Optional filter parameter. Holds the ID of the user who started the step.
- finishUserId
- Optional filter parameter. Holds the ID of the user who finished the step.
- dataUserId
- Optional filter parameter. Holds the ID of the user who entered the step data.
- formDone
- Optional filter parameter. Holds the flag value that indicates whether data entry has been performed at this step.
- spare1
- Optional filter parameter. Holds the contents of the user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of the user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of the user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of the user-defined spare4 field.
- spare5
- Optional filter parameter. Holds the contents of the user-defined spare5 field.
- spare6
- Optional filter parameter. Holds the contents of the user-defined spare6 field.
- lastEditBy
- Optional filter parameter. Holds the name of the user who created or last modified the record.
- lastEditAt
- Optional filter parameter. Holds the date and time of when the record was added or last modified.
- rowId
- Optional filter parameter. Holds unique row ID of the job step data record.
Return Value
Returns a DataSet that contains all the records in the Job_Step_Data 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 |
|---|---|
| wo_id | A string that is the ID of the work order. |
| oper_id | A string that is the ID of the operation. |
| seq_no | An integer that is the operation sequence number of the job. |
| step_no | An integer that is the step number. |
| lot_no | A string that is the lot number of the item that results from the job. |
| sublot_no | A string that is the sublot number of the item that results from the job. |
| state_cd | An integer that is the JobStateCode enumeration that indicates the step state. |
| collect_data | A Boolean that is a flag that indicates whether data collection is required for this step. |
| certify | A Boolean that is a flag that indicates whether certification is required for this step. |
| act_start_time_utc | A datetime that is the time the step was started, in UTC. |
| act_start_time_local | A datetime that is the time the step was started, in the local time of the entity. |
| act_start_time | A datetime that is the time the step was started, in the local time of the client application that is making the call. |
| act_finish_time_utc | A datetime that is the time the step was finished, in UTC. |
| act_finish_time_local | A datetime that is the time the step was finished, in the local time of the entity. |
| act_finish_time | A datetime that is the time the step was finished, in the local time of the client application that is making the call. |
| step_data | A string that is the data that was logged for the step. |
| step_data_time_utc | A datetime that is the time the step data was entered, in UTC. |
| step_data_time_local | A datetime that is the time the step data was entered, in the local time of the entity. |
| step_data_time | A datetime that is the time the step data was entered, in the local time of the client application that is making the call. |
| start_user_id | A string that is the ID of the user who started the step. |
| finish_user_id | A string that is the ID of the user who finished the step. |
| data_user_id | A string that is the ID of the user who entered the step data. |
| form_done | A Boolean that indicates whether data entry has been performed for this step. |
| spare1 | A string that is the contents of the user-defined spare1 field. |
| spare2 | A string that is the contents of the user-defined spare2 field. |
| spare3 | A string that is the contents of the user-defined spare3 field. |
| spare4 | A string that is the contents of the user-defined spare4 field. |
| spare5 | A string that is the contents of the user-defined spare5 field. |
| spare6 | A string that is the contents of the user-defined spare6 field. |
| 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. |
| row_id | An integer that is unique row ID of the record. |
| repeatability | A Boolean that is a flag that, if false, indicates that this step is done once per operation (e.g., a setup step for the operation) or, if true, that this step is done for every lot produced during the operation. |