GetAll(String,String,String,String,String,String,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,Nullable<DateTime>,Nullable<Int32>,Nullable<Int32>,String,String,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,String,String,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 9 minute read
The GetAll() method retrieves one or more work order records from the WO table, as specified by the filter parameters. Passing no filter parameters will retrieve all work order records from the table.
'Declaration
Public Overloads Shared Function GetAll( _
ByVal woId As String, _
ByVal woDesc As String, _
ByVal processId As String, _
ByVal bomVerId As String, _
ByVal specVerId As String, _
ByVal itemId As String, _
ByVal releaseTimeUtc As Nullable(Of Date), _
ByVal releaseTimeLocal As Nullable(Of Date), _
ByVal reqFinishTimeUtc As Nullable(Of Date), _
ByVal reqFinishTimeLocal As Nullable(Of Date), _
ByVal stateCd As Nullable(Of Integer), _
ByVal woPriority As Nullable(Of Integer), _
ByVal custInfo As String, _
ByVal moId As String, _
ByVal disassembly As Nullable(Of Boolean), _
ByVal mayOverrideRoute As Nullable(Of Boolean), _
ByVal overrideSerialization As Nullable(Of Boolean), _
ByVal inputWOId As String, _
ByVal inputOperId As String, _
ByVal inputSeqNo As Nullable(Of Integer), _
ByVal targetScheduleLineId As Nullable(Of Integer), _
ByVal queueSequenceNumber As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim woId As String
Dim woDesc As String
Dim processId As String
Dim bomVerId As String
Dim specVerId As String
Dim itemId As String
Dim releaseTimeUtc As Nullable(Of Date)
Dim releaseTimeLocal As Nullable(Of Date)
Dim reqFinishTimeUtc As Nullable(Of Date)
Dim reqFinishTimeLocal As Nullable(Of Date)
Dim stateCd As Nullable(Of Integer)
Dim woPriority As Nullable(Of Integer)
Dim custInfo As String
Dim moId As String
Dim disassembly As Nullable(Of Boolean)
Dim mayOverrideRoute As Nullable(Of Boolean)
Dim overrideSerialization As Nullable(Of Boolean)
Dim inputWOId As String
Dim inputOperId As String
Dim inputSeqNo As Nullable(Of Integer)
Dim targetScheduleLineId As Nullable(Of Integer)
Dim queueSequenceNumber As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = WO.GetAll(woId, woDesc, processId, bomVerId, specVerId, itemId, releaseTimeUtc, releaseTimeLocal, reqFinishTimeUtc, reqFinishTimeLocal, stateCd, woPriority, custInfo, moId, disassembly, mayOverrideRoute, overrideSerialization, inputWOId, inputOperId, inputSeqNo, targetScheduleLineId, queueSequenceNumber, lastEditBy, lastEditAt)
public static DataSet GetAll(
string woId,
string woDesc,
string processId,
string bomVerId,
string specVerId,
string itemId,
Nullable<DateTime> releaseTimeUtc,
Nullable<DateTime> releaseTimeLocal,
Nullable<DateTime> reqFinishTimeUtc,
Nullable<DateTime> reqFinishTimeLocal,
Nullable<int> stateCd,
Nullable<int> woPriority,
string custInfo,
string moId,
Nullable<bool> disassembly,
Nullable<bool> mayOverrideRoute,
Nullable<bool> overrideSerialization,
string inputWOId,
string inputOperId,
Nullable<int> inputSeqNo,
Nullable<int> targetScheduleLineId,
Nullable<int> queueSequenceNumber,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- woId
- Optional filter parameter. Holds the ID of the work order to be retrieved.
- woDesc
- Optional filter parameter. Holds the description of the work order to be retrieved.
- processId
- Optional filter parameter. Holds the ID of the process from which a work order was generated, if the work order was generated from a process.
- bomVerId
- Optional filter parameter. Holds a work order's BOM version ID.
- specVerId
- Optional filter parameter. Holds a work order's specification version ID.
- itemId
- Optional filter parameter. Holds the ID of an item for the work order.
- releaseTimeUtc
- Optional filter parameter. Holds a UTC date/time when a work order was/will be released.
- releaseTimeLocal
- Optional filter parameter. Holds an entity's local date/time when a work order was/will be released.
- reqFinishTimeUtc
- Optional filter parameter. Holds a UTC date/time by when a work order must be completed.
- reqFinishTimeLocal
- Optional filter parameter. Holds an entity's local date/time by when a work order must be completed.
- stateCd
Optional filter parameter. Holds a code that indicates a work order state. Valid codes are:
0 = Released (the default)
1 = Started
2 = Completed
3 = Closed. When closed, nothing else for this work order is editable.
- woPriority
- Optional filter parameter. Holds an integer that identifies the priority for a work order.
- custInfo
- Optional filter parameter. Holds a work order's customer information.
- moId
- Optional filter parameter. Holds the manufacturing order for a work order.
- disassembly
- Optional filter parameter. Holds a flag that indicates whether the work order is disassembling something.
- mayOverrideRoute
- Optional filter parameter. Holds a flag that indicates whether the work order can include operations other than those immediately upstream or downstream from the current one.
- overrideSerialization
- Optional filter parameter. Holds a flag that indicates whether an item that the work order is producing and that is normally treated as serialized, is not treated as serialized.
- inputWOId
- Optional filter parameter. Holds the work order ID of the job from which a rework work order would originate.
- inputOperId
- Optional filter parameter. Holds the operation ID of the job from which a rework work order would originate.
- inputSeqNo
- Optional filter parameter. Holds the operation sequence number of the job from which a rework work order would originate.
- targetScheduleLineId
- Optional filter parameter. Holds the ID of the line that a work order has been scheduled on.
- queueSequenceNumber
- Optional filter parameter. Holds the sequence number for a work order in a queue.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last edited a record.
- lastEditAt
- Optional filter parameter. Holds a date/time when the record was added or last edited.
Return Value
Returns a DataSet that contains records for all the work orders that satisfy the specified filters. If no matching work orders are found, an empty DataSet is returned. Column values are from the WO table unless otherwise indicated.
The columns of the returned DataSet are described below.
| Column Name | Description |
|---|---|
| wo_id | A string that is the work order ID. |
| wo_desc | A string that is the work order description. |
| process_id | A string that is the ID of the process from which the work order was created, if the work order was created from a process. |
| process_desc | A string that is the description of the process from which the work order was created, if the work order was created from a process. From the Process table. |
| bom_ver_id | A string that is the BOM version of the original item that this work order produces specified at the time it was created, unless created on-the-fly. |
| spec_ver_id | A string that is the specification version selected for all operations (if any) at the time the work order was created, unless created on-the-fly. |
| item_id | A string that is the ID of the final item being made, unless all its jobs are disassembly jobs, in which case this is the initial item. |
| item_desc | A string that is the item description. From the Item table. |
| serial_no_lvl |
An integer that is an enumeration that indicates how the serial number of the item being produced for the work order is determined. 0 = the lot number is the serial number. 1 or greater = the sublot level that is the serial number. -1 = serial numbers are not used (the default). From the Item table. |
| uom_id | An integer that is the ID of the unit of measure for the item being produced for the work order. From the Item table. |
| uom_desc | A string that is the description of the unit of measure for the item being produced for the work order. From the UOM table. |
| num_decimals | An integer that is the number of decimal places to use for quantities of the item. From the Item table. |
| num_decimals_good_pp | If num_decimals is 0, an integer that is the value of the system attribute Max decimals of good piece part entries (attr_id 326 in the System_Attr table), which is used to determine the number of decimal places to use for quantities of good item production. |
| req_qty | A double that is the required quantity of items to be produced for the work order. |
| release_time_utc | A datetime that indicates when the work order was or will be released, in UTC. |
| release_time_local | A datetime that indicates when the work order was or will be released, in the local time of the entity that is the production source for the item being produced for the work order. |
| release_time | A datetime value that indicates when the work order was or will be released, in the local time of the client application that is making the call. |
| req_finish_time_utc | A datetime value that indicates when the work order must be completed, in UTC. |
| req_finish_time_local | A datetime value that indicates when the work order must be completed, in the local time of the entity that is the production source for the item being produced for the work order. |
| req_finish_time | A datetime value that indicates when the work order must be completed, in the local time of the client application that is making the call. |
| state_cd |
An integer that is the code that indicates the state of the work order. 0 = Released (default). 1 = Started. 2 = Completed. 3 = Closed. When closed, nothing else for this work order is editable. |
| wo_priority | An integer that is the work order priority. This is used as the default priority for jobs in the work order. |
| cust_info | A string that is the customer information for the work order. |
| mo_id | A string that is the manufacturing order, for grouping different final parts. |
| production_schedule_id | A string that is the production schedule to which the work order (Production Request ID) belongs. |
| notes | A string that is the notes about the work order. |
| not_deletable | A Boolean that is a flag that indicates whether the work order can be deleted. |
| disassembly | A Boolean that is a flag that indicates whether the work order is disassembling something. |
| may_override_route | A Boolean that is a flag that indicates whether the work order can include operations other than those immediately upstream or downstream from the current one. |
| override_serialization | A Boolean that is a flag that indicates whether an item that the work order is producing and that is normally treated as serialized is not treated as serialized. |
| input_wo_id | A string that is the work order ID of the job from which a rework work order originates. |
| input_oper_id | A string that is the operation ID of the job from which a rework work order originates. |
| input_seq_no | An integer that is the operation sequence number of the job from which a rework work order originates. |
| target_sched_line_id | An integer that is the ID of the production line to which the work order is assigned. This will be null if the work order is not assigned to a line. |
| target_sched_line_name | A string that is the name of the production line to which the work order is assigned. This will be null if the work order is not assigned to a line. From the Line table. |
| queue_seq_no | An integer that is the sequence number of the work order in the queue. |
| wo_status |
An integer that is the code that indicates the status of the work order. 1 = New 2 = Ready 3 = Running (in progress) 4 = Complete 5 = Suspended 6 = On Hold |
| qty_reqd | A double that is the required quantity of items to be produced for the work order. |
| qty_at_start | A double that is the quantity of items that the work order is expected to produce if there is no rejected production (that is, if all production is good). If the work order is assigned to a line, this quantity is based on the jobs performed at the entities identified as the production source for the line. |
| qty_prod | A double that is the good quantity produced. |
| qty_rejected | A double that is the quantity rejected. |
| qty_remaining | A double that is the item quantity defined as the difference between the start quantity and the sum of the quantity produced and the quantity rejected (qty_at_start - (qty_prod + qty_rejected)). |
| def_reqd_qty | A double that is original required quantity less the good quantity produced in any job for this work order that runs on a line's production source entities, or 0, whichever is greater. |
| spare1 | A string that is the contents of the work order’s user-defined spare1 field. |
| spare2 | A string that is the contents of the work order’s user-defined spare2 field. |
| spare3 | A string that is the contents of the work order’s user-defined spare3 field. |
| spare4 | A string that is the contents of the work order’s user-defined spare4 field. |
| last_edit_comment | A string that is the comments about why record was added or last 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 specifies when the record was added or last updated. |
| mod_id | A string that is the current modification ID of the record in the WO 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. |
| calc_start_qty | A string that is the sum of items that the work order can optimally produce given the raw material available based on the jobs that are run on a line's production source entities. |
| calc_reqd_qty | A string that is the sum of items that the work order is required to produce given the raw material available based on the jobs that are run on a line's production source entities. |