GetAll Method (JobStepFile)
- Last UpdatedNov 06, 2025
- 2 minute read
'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 lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim stepNo As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = JobStepFile.GetAll(woId, operId, seqNo, stepNo, lastEditBy, lastEditAt)
public static DataSet GetAll(
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> stepNo,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- woId
- Optional filter parameter. Holds the ID of a work order associated with a job.
- operId
- Optional filter parameter. Holds the ID of an operation associated with a job.
- seqNo
- Optional filter parameter. Holds the operation sequence number to which a job steps belong.
- stepNo
- Optional filter parameter. Holds a job step number.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who added or last updated a job step file record.
- lastEditAt
- Optional filter parameter. Holds the date/time when a job step file record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Job_Step_File 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 sequence number. |
|
step_no |
An integer that is the step number. |
|
assoc_file |
A string that is the name of the associated file. |
|
assoc_file_type |
A string that is the file extension of the associated file. The file extension is pulled from the filename in the file_path column. |
|
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. |