GetJobSpecs Method
- Last UpdatedNov 06, 2025
- 2 minute read
The GetJobSpecs() method retrieves a list of all specifications of the job specification from the Job_Spec table.
'Declaration
Public Shared Function GetJobSpecs( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
ByVal stepNo 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 value As DataSet
value = JobSpec.GetJobSpecs(woId, operId, seqNo, stepNo)
public static DataSet GetJobSpecs(
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> stepNo
)
Parameters
- woId
Optional. Holds the ID of the work order.
- operId
Optional. Holds the ID of the operation.
- seqNo
Optional. Holds the operation sequence number of the job.
- stepNo
Optional. Holds the number of the step with which a specification is associated.
Return Value
Returns a DataSet that contains records for all the job specifications that satisfy the specified filters. The returned records include columns from the Job_Spec, and Spec tables. If no matching job specifications are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
ColumnName |
Description |
|---|---|
|
grp_id |
A string that is the ID of the spec group of which the specification is a member, from the Spec table. |
|
spec_id |
A string that is the ID of the specification, from Spec table. |
|
step_no |
An integer that is the number of the step with which the specification is associated. |
|
mod_id |
The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes. |
|
access_level |
An integer that is the security access level for modifying the specification. The default value is null. |
|
data_type |
An integer that is an enumeration that indicates the data type of the specification value, from the Spec table. 0 = string (the default) 1 = floating point number |