MES Stateless API

GetAll Method (ItemStorageExecLink)

Save PDF

GetAll Method (ItemStorageExecLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

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

'Usage
 
Dim entId As Nullable(Of Integer)
Dim itemId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = ItemStorageExecLink.GetAll(entId, itemId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> entId,
   string itemId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

entId

Optional filter parameter. Holds the ID of an entity.

itemId

Optional filter parameter. Holds the ID of an item.

lastEditBy

Optional filter parameter. Holds the ID of the user who added or last updated a item storage execution link record.

lastEditAt

Optional filter parameter. Holds the date/time when a item storage execution link record was added or last updated.

Return Value

Returns a DataSet that contains records for all the item storage execution links that satisfy the specified filters. The returned records include columns from the Item_Storage_Exec_Link and Ent tables. If no matching item storage records are found, an empty DataSet is returned.

ColumnName	Description
ent_id	An integer that is the ID of an entity.
item_id	A string that is the item whose inventory level is to be monitored.
min_inv_level	A double-precision floating point number that is the amount of the item stored here below which a replinishment order should be generated. If the inventory level is less than the minimum, then a work order will be generated to replenish the inventory. This is the minimum amount of inventory that can be stored here below which a replenishment order should be generated.
min_reorder_amt	A double-precision floating point number that is the minimum quantity of the replenishment order.
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 date/time that indicates when the record was added or last updated.
ent_name	A string that is the name of the entity.

MES Stateless API