MES Stateless API

GetAll Method (StorageExec)

Save PDF

GetAll Method (StorageExec)

Save PDF

Last UpdatedNov 06, 2025
6 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal entId As Nullable(Of Integer), _
   ByVal type As String, _
   ByVal status As Nullable(Of Integer), _
   ByVal maxCapacity As Nullable(Of Double), _
   ByVal uomId As Nullable(Of Integer), _
   ByVal tare As Nullable(Of Double), _
   ByVal tareUomId As Nullable(Of Integer), _
   ByVal autoDelZeroInv As Nullable(Of Boolean), _
   ByVal allowNegQty As Nullable(Of Boolean), _
   ByVal scannableId As String, _
   ByVal allowMultipleItems As Nullable(Of Boolean), _
   ByVal allowMultipleLots As Nullable(Of Boolean), _
   ByVal movable As Nullable(Of Boolean), _
   ByVal storageEntId As Nullable(Of Integer), _
   ByVal allowDirtyState As Nullable(Of Boolean), _
   ByVal logStateTransitions As Nullable(Of Boolean), _
   ByVal indistinguishableLots As Nullable(Of Boolean), _
   ByVal unlisted As Nullable(Of Boolean), _
   ByVal spareInt1 As Nullable(Of Integer), _
   ByVal spareInt2 As Nullable(Of Integer), _
   ByVal spareInt3 As Nullable(Of Integer), _
   ByVal spareInt4 As Nullable(Of Integer), _
   ByVal spare1 As String, _
   ByVal spare2 As String, _
   ByVal spare3 As String, _
   ByVal spare4 As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim entId As Nullable(Of Integer)
Dim type As String
Dim status As Nullable(Of Integer)
Dim maxCapacity As Nullable(Of Double)
Dim uomId As Nullable(Of Integer)
Dim tare As Nullable(Of Double)
Dim tareUomId As Nullable(Of Integer)
Dim autoDelZeroInv As Nullable(Of Boolean)
Dim allowNegQty As Nullable(Of Boolean)
Dim scannableId As String
Dim allowMultipleItems As Nullable(Of Boolean)
Dim allowMultipleLots As Nullable(Of Boolean)
Dim movable As Nullable(Of Boolean)
Dim storageEntId As Nullable(Of Integer)
Dim allowDirtyState As Nullable(Of Boolean)
Dim logStateTransitions As Nullable(Of Boolean)
Dim indistinguishableLots As Nullable(Of Boolean)
Dim unlisted As Nullable(Of Boolean)
Dim spareInt1 As Nullable(Of Integer)
Dim spareInt2 As Nullable(Of Integer)
Dim spareInt3 As Nullable(Of Integer)
Dim spareInt4 As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = StorageExec.GetAll(entId, type, status, maxCapacity, uomId, tare, tareUomId, autoDelZeroInv, allowNegQty, scannableId, allowMultipleItems, allowMultipleLots, movable, storageEntId, allowDirtyState, logStateTransitions, indistinguishableLots, unlisted, spareInt1, spareInt2, spareInt3, spareInt4, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> entId,
   string type,
   Nullable<int> status,
   Nullable<double> maxCapacity,
   Nullable<int> uomId,
   Nullable<double> tare,
   Nullable<int> tareUomId,
   Nullable<bool> autoDelZeroInv,
   Nullable<bool> allowNegQty,
   string scannableId,
   Nullable<bool> allowMultipleItems,
   Nullable<bool> allowMultipleLots,
   Nullable<bool> movable,
   Nullable<int> storageEntId,
   Nullable<bool> allowDirtyState,
   Nullable<bool> logStateTransitions,
   Nullable<bool> indistinguishableLots,
   Nullable<bool> unlisted,
   Nullable<int> spareInt1,
   Nullable<int> spareInt2,
   Nullable<int> spareInt3,
   Nullable<int> spareInt4,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

entId: Optional filter parameter. Holds the ID of an entity that can store material.
type: Optional filter parameter. Holds a user-defined string used for sorting.
status: Optional filter parameter. Holds the status of the storage entity.
maxCapacity: Optional filter parameter. Holds the maximum storage capacity.
uomId: Optional filter parameter. Holds the unit of measure for MaxCapacity.
tare: Optional filter parameter. Holds the weight of the entity when empty.
tareUomId: Optional filter parameter. Holds the unit of measure for the tare weight.
autoDelZeroInv: Optional filter parameter. Holds a flag that specifies whether the row from the Item_Inventory table be deleted when the quantity left is less than or equal to zero.
allowNegQty: Optional filter parameter. Holds a flag that specifies whether negative quantity left values be allowed.
scannableId: Optional filter parameter. Holds a flag that specifies whether a bar code scan can be used to uniquely identify the entity.
allowMultipleItems: Optional filter parameter. Holds a flag that specifies whether different items can be stored within this storage entity.
allowMultipleLots: Optional filter parameter. Holds a flag that specifies whether different lot numbers can be stored within this entity.
movable: Optional filter parameter. Holds a flag that specifies whether this storage entity is movable.
storageEntId: Optional filter parameter. Holds another entity where this storage entity is currently located (only used when this storage entity is movable).
allowDirtyState: Optional filter parameter. Holds a flag that specifies whether the Dirty state (status = 2) is available for this storage entity.
logStateTransitions: Optional filter parameter. Holds a flag that specifies whether state transitions are logged for this entity.
indistinguishableLots: Optional filter parameter. Holds a flag that specifies whether inventory stored in this entity cannot be separated by lot number when consumed, shipped, or transferred out.
unlisted: Optional filter parameter. Holds a flag that specifies whether this entity will not show up in certain trees and lists of storage entities.
spareInt1: Optional filter parameter. Holds the contents of the user-defined spare1 integer field.
spareInt2: Optional filter parameter. Holds the contents of the user-defined spare2 integer field.
spareInt3: Optional filter parameter. Holds the contents of the user-defined spare3 integer field.
spareInt4: Optional filter parameter. Holds the contents of the user-defined spare4 integer field.
spare1: Optional filter parameter. Holds the contents of the user-defined spare1 string field.
spare2: Optional filter parameter. Holds the contents of the user-defined spare2 string field.
spare3: Optional filter parameter. Holds the contents of the user-defined spare3 string field.
spare4: Optional filter parameter. Holds the contents of the user-defined spare4 string field.
lastEditBy: Optional filter parameter. Holds the user who added or last changed a record.
lastEditAt: Optional filter parameter. Holds the date/time when a record was added or last edited.

Return Value

Returns a DataSet that contains all the records in the Storage_Exec 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
ent_id	An integer that is the Id of the entity, from the Storage_Exec table.
ent_name	A string that is unique name of the entity, from the ent.ent_name column.
type	A string that is the type, from the Storage_Exec table.
status	A string that is the status value, from the Storage_Exec table. For example, it returns 0 for Available, 1 for Used, 2 for Dirty.
max_capacity	A double that is the maximum capacity, from the Storage_Exec table.
uom_id	An integer that is the unit of measurement (UOM) for the maximum capacity, from the Storage_Exec table.
tare	A double that is the tare, from the Storage_Exec table.
tare_uom_id	An integer that is the ID of the tare UOM, from the Storage_Exec table.
auto_del_zero_inv	A Boolean that is a flag that indicates whether to delete the row in the Item_Inventory table when quantity is left at or below zero, from the Storage_Exec table.
allow_neq_qty	A Boolean that is a flag that indicates whether negative quantity is allowed, from the Storage_Exec table.
scannable_id	A string that is the scannable bar code ID for uniquely identifies the entity, from the Storage_Exec table.
allow_multiple_lots	A Boolean that is a flag that indicates whether to allow multiple lots, from the Storage_Exec table.
movable	A Boolean that is a flag that indicates whether the storage location is movable, from the Storage_Exec table.
storage_ent_id	An integer that is the storage entity ID, from the Storage_Exec table.
storage_ent_name	A string that is the storage entity name, from the ent.ent_name column.
allow_dirty_state	A Boolean that is a flag that indicates whether to allow the Dirty state, from the Storage_Exec table.
log_state_transitions	A Boolean that is a flag that indicates whether state transitions are logged for this entity, from the Storage_Exec table.
indistinguishable_lots	A Boolean that is a flag that indicates whether the inventory stored in this entity cannot be separated by lot number when consumed, shipped, or transferred out, from the Storage_Exec table.
unlisted	A Boolean that is a flag that indicates whether this entity will not show up in certain trees and lists of storage entities, from the Storage_Exec table.
spare_int1	An integer that is the content of the user-defined spare1 integer field, from the Storage_Exec table.
spare_int2	An integer that is the content of the user-defined spare2 integer field, from the Storage_Exec table.
spare_int3	An integer that is the content of the user-defined spare3 integer field, from the Storage_Exec table.
spare_int4	An integer that is the content of the user-defined spare4 integer field, from the Storage_Exec table.
spare1	A string that is the content of the user-defined spare1 string field, from the Storage_Exec table.
spare2	A string that is the content of the user-defined spare2 string field, from the Storage_Exec table.
spare3	A string that is the content of the user-defined spare3 string field, from the Storage_Exec table.
spare4	A string that is the content of the user-defined spare4 string field, from the Storage_Exec table.
last_edit_comment	A string that contains comments about why the record was changed.
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.
description	A string that is a unique description of the unit of measurement, from the uom.description column.
abbreviation	A string that is the abbreviation of the unit of measurement to append to the quantities, from the uom.abbreviation column.

MES Stateless API

GetAll Method (StorageExec)

Table of Contents

GetAll Method (StorageExec)

In This Topic

MES Stateless API

GetAll Method (StorageExec)

Syntax

Parameters

Return Value

Remarks

See Also

Reference

In This Topic