GetAll Method (ReworkProcessUsage)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAll() method retrieves one or more rework process usage records from the Rework_Process_Usage table, as specified by the filter parameters. Passing no filter parameters will retrieve all rework process usage records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal reasonCd As Nullable(Of Integer), _
ByVal originalReworkCd As String, _
ByVal originalProcessId As String, _
ByVal itemId As String, _
ByVal reworkProcessId As String, _
ByVal reentryReworkCd As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal rowId As Nullable(Of Integer) _
) As DataSet
'Usage
Dim reasonCd As Nullable(Of Integer)
Dim originalReworkCd As String
Dim originalProcessId As String
Dim itemId As String
Dim reworkProcessId As String
Dim reentryReworkCd As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim value As DataSet
value = ReworkProcessUsage.GetAll(reasonCd, originalReworkCd, originalProcessId, itemId, reworkProcessId, reentryReworkCd, lastEditBy, lastEditAt, rowId)
public static DataSet GetAll(
Nullable<int> reasonCd,
string originalReworkCd,
string originalProcessId,
string itemId,
string reworkProcessId,
string reentryReworkCd,
string lastEditBy,
Nullable<DateTime> lastEditAt,
Nullable<int> rowId
)
Parameters
- reasonCd
- Optional filter parameter. Holds a reason code that specifies the reason entered for the item, which necessitates rework.
- originalReworkCd
- Optional filter parameter. Holds the rework code for the job(s) from which the rework originates.
- originalProcessId
- Optional filter parameter. Holds the ID of the process of the work order from which the rework originates. If set to null in a record, indicates that rework requirements are not differentiated by process.
- itemId
- Optional filter parameter. Holds the ID of the item produced. If set to null, indicates that rework requirements are not differentiated by item.
- reworkProcessId
- Optional filter parameter. Holds the ID of the process that comprises a set of rework operations to be done.
- reentryReworkCd
- Optional filter parameter. Holds the rework code of the next downstream job to which the material is to be returned once reworked, if rework is part of the original work order. If set to null, indicates that it is the very next job.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last updated the rework record.
- lastEditAt
- Optional filter parameter. Holds a date/time when the record was added or last edited.
- rowId
- Optional filter parameter. Holds an integer that is a unique identifier for the row.
Return Value
Returns a DataSet that contains the records in the Rework_Process_Usage 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 |
|---|---|
|
reas_cd |
An integer that is the reason entered for the item, which necessitates rework. |
|
orig_rework_cd |
A string that is a rework code for the job(s) from which rework originates. |
|
orig_process_id |
A string that is the ID of the process of the work order from which rework originates. If set to null (the default), then rework requirements are not differentiated by process. |
|
item_id |
A string that is the ID of the item produced. If set to null (the default), then rework requirements are not differentiated by item. |
|
rework_process_id |
A string that is the ID of the process that comprises a set of rework operations to be done. |
|
max_times_rework |
An integer that is how many times the smallest identifiable group of production can be reworked for this. Set to null (the default) if there is no limit. |
|
reentry_rework_cd |
A string that is the rework code of the next downstream job to which the material is to be returned once reworked, if rework is part of the original work order. If set to If null (the default), it is the very next job. |
|
last_edit_comment |
A string that contains comments about why record was changed. |
|
last_edit_by |
A string that is the ID of the user that last edited this record. |
|
last_edit_at |
A datetime that specifies when the record was added or last modified. |
|
row_id |
An integer that is a unique row identifier for the record. |