GetByFilter Method (ReworkProcessUsage)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetByFilter() 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 process records from the table.
'Declaration
Public Shared Function GetByFilter( _
ByVal reasonGroup As Nullable(Of Integer), _
ByVal reasonCd As Nullable(Of Integer), _
ByVal originalReworkCd As String, _
ByVal originalProcessId As String, _
ByVal itemId As String _
) As DataSet
'Usage
Dim reasonGroup As Nullable(Of Integer)
Dim reasonCd As Nullable(Of Integer)
Dim originalReworkCd As String
Dim originalProcessId As String
Dim itemId As String
Dim value As DataSet
value = ReworkProcessUsage.GetByFilter(reasonGroup, reasonCd, originalReworkCd, originalProcessId, itemId)
public static DataSet GetByFilter(
Nullable<int> reasonGroup,
Nullable<int> reasonCd,
string originalReworkCd,
string originalProcessId,
string itemId
)
Parameters
- reasonGroup
- Optional filter parameter. Holds the ID of a reason group.
- 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 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 in a record, indicates that it is the very next job.
- 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 in a record, indicates that rework requirements are not differentiated by item.
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. |
|
reas_desc |
A string that is the description of the item reason, from the Item_Reas table. |
|
reas_grp_id |
An integer that is ID of the reason group of which the item reason is a part, from the Item_Reas table. |
|
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 identifier for row. |