GetDynamicRoutesByFilter Method
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetDynamicRoutesByFilter( _
ByVal originalProcessId As String, _
ByVal originalOperId As String, _
ByVal itemFilters() As String, _
ByVal reworkCdFilters() As String, _
ByVal itemReasonFilters() As Integer _
) As DataSet
'Usage
Dim originalProcessId As String
Dim originalOperId As String
Dim itemFilters() As String
Dim reworkCdFilters() As String
Dim itemReasonFilters() As Integer
Dim value As DataSet
value = Process.GetDynamicRoutesByFilter(originalProcessId, originalOperId, itemFilters, reworkCdFilters, itemReasonFilters)
public static DataSet GetDynamicRoutesByFilter(
string originalProcessId,
string originalOperId,
string[] itemFilters,
string[] reworkCdFilters,
int[] itemReasonFilters
)
Parameters
- originalProcessId
- Required. Holds the ID of the process from which the rework originates.
- originalOperId
- Optional. Holds the ID of the operation from which the rework originates.
- itemFilters
- Optional. Holds an array that contains the item IDs by which to filter the routes that are being retrieved.
- reworkCdFilters
- Optional. Holds an array that contains the rework codes by which to filter the routes that are being retrieved.
- itemReasonFilters
- Optional. Holds an array that contains the item reason codes by which to filter the routes that are being retrieved.
Return Value
Returns a DataSet that contains the route records 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 |
|---|---|
|
rework_process_id |
A string that is the ID of a process that includes rework operations. |
|
oper_id |
A string that is the ID of the operation of the rework process. |
|
oper_desc |
A string that is the description for the operation of the rework process. |
|
orig_rework_cd |
A string that is a rework code for the job(s) from which the rework originates. |
|
orig_process_id |
A string that is the ID of the process from which the rework originates. This value is null (the default) if the rework is being done within the same process that it originated. |
|
orig_oper_id |
A string that is the ID of the operation of the process from which the rework originates. This value is null if the rework is not tied to an operation for the process. |
|
reas_cd |
An integer that is the code for the reason entered for the item, which necessitates rework, from the Item_Reas table. |
|
reas_desc |
A string that is the description of the item reason, from the Item_Reas table. |
|
reas_grp_id |
An integer that is the reason group of which the item reason is a member, from the Item_Reas table. |
|
item_id |
A string that is the ID of the item produced. This value is null (the default) if rework requirements are not differentiated by item. |
|
max_times_rework |
An integer that is how many times the smallest identifiable group of production can be reworked. This value is 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. This value is null (the default) if it is the very next job. |
|
display_seq |
An integer that is the position within the process that this job should be displayed. |
|
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 is the date/time when the record was added or last modified. |