GetAll(String,String,String,String,ProcessLevel,ProcessStatus,String,String,Nullable<DateTime>,String,Nullable<DateTime>,String,Nullable<DateTime>,Nullable<Boolean>,Nullable<Boolean>,Nullable<Boolean>,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 5 minute read
The GetAll() method retrieves one or more process records from the Process table, as specified by the filter parameters. Passing no filter parameters will retrieve all process records from the table.
'Declaration
Public Overloads Shared Function GetAll( _
ByVal processId As String, _
ByVal processClassId As String, _
ByVal processVerId As String, _
ByVal processDesc As String, _
ByVal processLevel As ProcessLevel, _
ByVal processStatus As ProcessStatus, _
ByVal creator As String, _
ByVal approver As String, _
ByVal createdAt As Nullable(Of Date), _
ByVal lastUserToChangeStatus As String, _
ByVal lastStatusChangeAt As Nullable(Of Date), _
ByVal checkedOutBy As String, _
ByVal lastInstantiated As Nullable(Of Date), _
ByVal disassembly As Nullable(Of Boolean), _
ByVal mayOverrideRoute As Nullable(Of Boolean), _
ByVal rework As Nullable(Of Boolean), _
ByVal lastEditor As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim processId As String
Dim processClassId As String
Dim processVerId As String
Dim processDesc As String
Dim processLevel As ProcessLevel
Dim processStatus As ProcessStatus
Dim creator As String
Dim approver As String
Dim createdAt As Nullable(Of Date)
Dim lastUserToChangeStatus As String
Dim lastStatusChangeAt As Nullable(Of Date)
Dim checkedOutBy As String
Dim lastInstantiated As Nullable(Of Date)
Dim disassembly As Nullable(Of Boolean)
Dim mayOverrideRoute As Nullable(Of Boolean)
Dim rework As Nullable(Of Boolean)
Dim lastEditor As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Process.GetAll(processId, processClassId, processVerId, processDesc, processLevel, processStatus, creator, approver, createdAt, lastUserToChangeStatus, lastStatusChangeAt, checkedOutBy, lastInstantiated, disassembly, mayOverrideRoute, rework, lastEditor, lastEditAt)
public static DataSet GetAll(
string processId,
string processClassId,
string processVerId,
string processDesc,
ProcessLevel processLevel,
ProcessStatus processStatus,
string creator,
string approver,
Nullable<DateTime> createdAt,
string lastUserToChangeStatus,
Nullable<DateTime> lastStatusChangeAt,
string checkedOutBy,
Nullable<DateTime> lastInstantiated,
Nullable<bool> disassembly,
Nullable<bool> mayOverrideRoute,
Nullable<bool> rework,
string lastEditor,
Nullable<DateTime> lastEditAt
)
Parameters
- processId
- Optional filter parameter. Holds the ID of a process that is being retrieved.
- processClassId
- Optional filter parameter. Holds the ID of a process class of which the processes are versions.
- processVerId
- Optional filter parameter. Holds the ID of a process version.
- processDesc
- Optional filter parameter. Holds a process description.
- processLevel
- Required filter parameter. Holds an enumeration value of the process level.
- processStatus
- Required filter parameter. Holds an enumeration value of the process status.
- creator
- Optional filter parameter. Holds a user ID of the user who added the process(es).
- approver
- Optional filter parameter. Holds a user ID of the user who approved the process(es).
- createdAt
- Optional filter parameter. Holds the date/time when the process was added, in UTC.
- lastUserToChangeStatus
- Optional filter parameter. Holds the user ID of last user who changed the status of the process.
- lastStatusChangeAt
- Optional filter parameter. Holds the date/time when the process' status was last changed, in UTC.
- checkedOutBy
- Optional filter parameter. Holds the user ID of the user who currently has the process(es) checked out. Pass a null to filter by processes that are not checked out.
- lastInstantiated
- Optional filter parameter. Holds the last date/time that a work order was successfully instantiated from this process, in UTC.
- disassembly
- Optional filter parameter. Holds a flag that indicates whether a process is disassembling something into its components.
- mayOverrideRoute
- Optional filter parameter. Holds a flag that indicates if certain methods can include operations other than those immediately upstream or downstream from the current one.
- rework
- Optional filter parameter. Holds a flag that indicates whether this process is for rework and not production.
- lastEditor
- Optional filter parameter. Holds the ID of the user who added or last changed the process 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 process records in the Process 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 |
The ID of the process, from the Process table. |
|
process_class_id |
The ID of the process class of which this process is a version, from the Process table. |
|
process_ver_id |
The ID of the process version, from the Process table. |
|
process_desc |
The description of the process, from the Process table. |
|
process_level |
The enumeration value for the process level. |
|
process_status |
The enumeration value for the process status. |
|
creator |
The user ID of the user who created the process, from the Process table. |
|
approver |
The user ID of the user who approved the process, from the Process table. |
|
created_at |
When this process version was created and is returned, from the Process table. |
|
last_user_to_change_status |
The user ID of the user who last changed the status of the process, from the Process table. |
|
last_status_change_at |
The date/time when the process status was last changed, from the Process table. |
|
checked_out_by |
The user ID of the user who currently has the process checked out, from the Process table. |
|
last_instantiated |
The last date/time that the process was used to successfully create a work order, from the Process table. |
|
disassembly |
A Boolean that is a flag that indicates whether this process can disassemble something into its components, from the Process table. |
|
may_override_route |
A Boolean that is a flag that indicates whether the process’ operations can be run out of sequence, from the Process table. |
|
rework |
A Boolean that is a flag that indicates that the process is for rework and not production, from the Process table. |
|
notes |
Holds notes about the process, from the Process table. |
|
creator_desc |
Holds the description of the user who created the process, from the Process table. |
|
approver_desc |
Holds the description of the user who approved the process, from the Process table. |
|
last_editor_desc |
The description of the user who added or last changed the record, from the Process table. |
|
last_user_to_change_status_des |
The description of the user who last changed the status of the process, from the Process table. |
|
checked_out_by_desc |
The description of the user who currently has the process checked out, from the Process table. |
|
spare1 |
A string that is the contents of the user-defined spare1 field, from the Process table. |
|
spare2 |
A string that is the contents of the user-defined spare2 field, from the Process table. |
|
spare3 |
A string that is the contents of the user-defined spare3 field, from the Process table. |
|
spare4 |
A string that is the contents of the user-defined spare4 field, from the Process table. |
|
last_edit_comment |
A string that contains comments about why the record was changed, from the Process table. |
|
last_editor |
A string that is the ID of the user who last edited this record, from the Process table. |
|
last_edit_at |
A datetime that specifies when the record was added or last updated, from the Process 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 Process table. |