GetAll Method (Oper)
- Last UpdatedNov 06, 2025
- 4 minute read
The GetAll() method retrieves one or more operation records from the Oper table, as specified by the filter parameters. Passing no filter parameters will retrieve all operation records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal processId As String, _
ByVal operId As String, _
ByVal operDesc As String, _
ByVal firstOper As Nullable(Of Boolean), _
ByVal finalOper As Nullable(Of Boolean), _
ByVal checkInv As Nullable(Of Boolean), _
ByVal schedToEntId As Nullable(Of Integer), _
ByVal operType As String, _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim processId As String
Dim operId As String
Dim operDesc As String
Dim firstOper As Nullable(Of Boolean)
Dim finalOper As Nullable(Of Boolean)
Dim checkInv As Nullable(Of Boolean)
Dim schedToEntId As Nullable(Of Integer)
Dim operType As String
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Oper.GetAll(processId, operId, operDesc, firstOper, finalOper, checkInv, schedToEntId, operType, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
string processId,
string operId,
string operDesc,
Nullable<bool> firstOper,
Nullable<bool> finalOper,
Nullable<bool> checkInv,
Nullable<int> schedToEntId,
string operType,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- processId
- Optional filter parameter. Holds the ID of the process to which the operations being retrieved belong.
- operId
- Optional filter parameter. Holds the ID of the operation.
- operDesc
- Optional filter parameter. Holds the operation description.
- firstOper
- Optional filter parameter. Holds a flag that specifies whether this is the first operation of the process.
- finalOper
- Optional filter parameter. Holds a flag that specifies whether this is the final operation of the process.
- checkInv
- Optional filter parameter. Holds a flag that specifies whether sufficient component inventory is required to change to the Ready state.
- schedToEntId
- Optional filter parameter. Holds the ID of the entity to which the operation should be scheduled.
- operType
- Optional filter parameter. Holds the type of operation. Can be used to help determine which job instances to create when importing schedules from an ERP system.
- spare1
- Optional filter parameter. Optional. Holds the contents of the user-defined spare1 field.
- spare2
- Optional filter parameter. Optional. Holds the contents of the user-defined spare2 field.
- spare3
- Optional filter parameter. Optional. Holds the contents of the user-defined spare3 field.
- spare4
- Optional filter parameter. Optional. Holds the contents of the user-defined spare4 field.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last changed the operation record.
- lastEditAt
- Optional filter parameter. Holds a date/time when the record was added or last edited.
Return Value
Returns a DataSet that contains all the operation records in the Oper 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 |
|---|---|
|
process_id |
A string that is the process ID, from the Oper table. |
|
oper_id |
A string that is the operation ID, from the Oper table. |
|
process_desc |
A string that is the process description is returned from the Process table |
|
def_reject_rate |
A double that is the defect rejection rate, from the oper table |
|
first_oper |
A Boolean that isa flag that specifies whether this is the first operation of the process, from the Oper table. |
|
final_oper |
A Boolean that isa flag that specifies whether this is the final operation of the process, from the Oper table. |
|
display_seq |
An integer that is the the sequence of operations, from the Oper table, independent of the operation ID. Used to sequence operations in tree and flow diagrams. |
|
check_inv |
A Boolean that is a flag that indicates whether sufficient component inventory is required to change to the Ready state, from the Oper table. |
|
sched_to_ent_id |
An integer that is the the ID of the entity to which the operation should be scheduled, from the Oper table. |
|
oper_type |
A string that is the type of operation, from the Oper table. Can be used to help determine which job instances to create when importing schedules from an ERP system. |
|
oper_cost |
A double that is the the additional (non-labor, non-machine, or non-material) cost associated specifically with this operation, from the Oper table. |
|
deviation_above |
A double that is the portion of the start quantity above which total production can deviate, from the Oper table. |
|
deviation_below |
A double that is the portion of the start quantity below which total production can deviate, from the Oper table. |
|
assoc_file |
A string that is the associated file for this operation, from the Oper table. |
|
assoc_file_type |
A string that is the type of the associated file, from the Oper table. |
|
rework_cd |
A string that is the rework behavior for this operation, from the Oper table. |
|
notes |
A string that is the notes about this operation, from the Oper table. |
|
spare1 |
A string that is the contents of the user-defined spare1 field, from the Oper table. |
|
spare2 |
A string that is the contents of the user-defined spare2 field, from the Oper table. |
|
spare3 |
A string that is the contents of the user-defined spare3 field, from the Oper table. |
|
spare4 |
A string that is the contents of the user-defined spare4 field, from the Oper table. |
|
last_edit_comment |
A string that contains comments about why record was changed, from the Oper table. |
|
last_edit_by |
A string that is the ID of the user that last edited this record, from the Oper table. |
|
last_edit_at |
A datetime that specifies when the record was added or last modified, from the Oper table. |
|
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. From the Oper table. |