GetProducedItems Method
- Last UpdatedNov 06, 2025
- 2 minute read
The GetProducedItems() method retrieves either all items produced by the specified process or all processes that produce the specified item.
'Declaration
Public Shared Function GetProducedItems( _
ByVal itemId As String, _
ByVal processId As String, _
ByVal operExist As Nullable(Of Boolean) _
) As DataSet
'Usage
Dim itemId As String
Dim processId As String
Dim operExist As Nullable(Of Boolean)
Dim value As DataSet
value = Process.GetProducedItems(itemId, processId, operExist)
Parameters
- itemId
- Optional. Holds the ID of the item, for retrieving all processes that produce that item.
- processId
- Optional. Holds the ID of the process, for retrieving all items that are produced by that process.
- operExist
- Optional. Holds a flag that indicates whether this method returns the processes that have at least one operation defined, excluding any processes that do not have any operations defined.
Return Value
Returns a DataSet that contains all items produced by the specified process or all processes that produce the specified item. If no matching items 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 in which the item is produced, from the Item_Process_Link table. |
|
item_id |
The ID of the produced item, from the Item_Process_Link table. |
|
item_desc |
The description of the produced item, from the Item table. |
|
item_class_id |
The ID of the item class of the produced item, from the Item_Class table. |
|
item_class_desc |
The description of the item class of the produced item, from the Item_Class table. |
This method lists all processes and the items that can be produced by the process. If the optional process_id is included, then this method returns only the process_id which is included, along with all the items that can be produced by the process. If the optional item_id is included, then this method returns all the process that can produce the specified item. If operExist flag is true, then this method returns the processes that have at least one operation defined, and the processes that do not have any operations defined are excluded from the returned DataSet.