MES Stateless API

GetAll Method (ItemProcessLink)

Save PDF

GetAll Method (ItemProcessLink)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAll() method retrieves one or more item/process link records from the Item_Process_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all item/process link records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal itemId As String, _
   ByVal processId As String, _
   ByVal itemPref As Nullable(Of Integer), _
   ByVal status As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date), _
   ByVal modId As String _
) As DataSet

'Usage
 
Dim itemId As String
Dim processId As String
Dim itemPref As Nullable(Of Integer)
Dim status As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim modId As String
Dim value As DataSet
 
value = ItemProcessLink.GetAll(itemId, processId, itemPref, status, lastEditBy, lastEditAt, modId)

public static DataSet GetAll( 
   string itemId,
   string processId,
   Nullable<int> itemPref,
   Nullable<int> status,
   string lastEditBy,
   Nullable<DateTime> lastEditAt,
   string modId
)

Parameters

itemId: Optional filter parameter. Holds the ID of an item whose item/process links are being retrieved.
processId: Optional filter parameter. Holds the ID of a process whose item/process links are being retrieved.
itemPref: Optional filter parameter. Holds an integer that is used to identify the preferred process. The process with the lowest value in this field is the preferred one.
status: Optional filter parameter. Holds an integer that indicates the status of this item/process combination.

-1=Disabled

1=Experimental

2=Approved (the default)

3=Certified)
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated a item/process link record.
lastEditAt: Optional filter parameter. Holds the date/time when a item/process link record was added or last updated.
modId: Optional filter parameter. Holds the modification ID that indicates when a item/process link record was added or last updated.

Return Value

Returns a DataSet that contains records for all the item/process links that satisfy the specified filters. The returned records include columns from the Item, Process, and Item_Class tables. If no matching item/process links are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
item_id	A string that is the ID of the item to be made.
process_id	A string that is the ID of the process used to make the item.
item_pref	An integer that identifies the preferred process (the process with the lowest value in this field is the preferred one).
status	An integer that indicates the status of this process/item combination: -1=Disabled 1=Experimental 2=Approved (the default) 3=Certified
item_desc	A string that is the description for the item, from the Item table.
item_display	A string that is a value that indicates what format to use to display the item identification in the user interface. The format values are defined in the system attribute Item display (attr_id 210 in the System_Attr table). Possible values and their formats are: 0 = item_id 1 = item_desc 2 = item_id(item_desc) 3 = item_desc(item_id)
num_decimals	An integer that is the number of decimals for formatting numeric values.
uom_id	An integer that is the ID of the unit of measure. If the job UOM ID is non-null, then this value comes from the Job table. Otherwise, this value comes from the Item table.
uom_description	A string that is the description for the unit of measure, from the Uom table.
process_desc	A string that is the description for the process, from the Process table.
process_status	An integer that indicates the status of the process, from the Process table: -1 = Disabled 1 = Experimental (the default) 2 = Approved 3 = Certified
process_level	An integer that specifies the process level, from the Process table: 1 = General 2 = Site 3 = Master (the default)
item_class_id	A string that is the ID of the item class, from the Item_Class table.
item_class_desc	A string that is the description for the item class, from the Item_Class table.
last_edit_comment	A string that contains comments about why the record was added or updated.
last_edit_by	A string that is the ID of the user who added or last updated this record.
last_edit_at	A datetime that indicates when the record was added or last updated.
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.

MES Stateless API