MES Stateless API

GetAll Method (ItemState)

Save PDF

GetAll Method (ItemState)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAll() method retrieves one or more item state records from the Item_State table, as specified by the filter parameters. Passing no filter parameters will retrieve all item state records from the table.The GetAll() method retrieves one or more item records from the Item table, as specified by the filter parameters. Passing no filter parameters will retrieve all item records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal itemStatusCd As Nullable(Of Integer), _
   ByVal itemStatusDesc As String, _
   ByVal color As Nullable(Of Integer), _
   ByVal pref As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim itemStatusCd As Nullable(Of Integer)
Dim itemStatusDesc As String
Dim color As Nullable(Of Integer)
Dim pref As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = ItemState.GetAll(itemStatusCd, itemStatusDesc, color, pref, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> itemStatusCd,
   string itemStatusDesc,
   Nullable<int> color,
   Nullable<int> pref,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

itemStatusCd: Required. Holds the code for an item state.
itemStatusDesc: Required. Holds the description for an item state.
color: Required. Holds an integer that indicates a state's RGB background color in the user interface.
pref: Holds a number that indicates the preference ordering of the state. Used in shipping and consumption. Must be greater than 0. The default is 1.
lastEditBy: Optional filter parameter. Holds the ID of a user who added or last updated this type of record.
lastEditAt: Optional filter parameter. Holds a date/time when this type of record was added or last updated.

Return Value

Returns a DataSet that contains all the records in the Item_State 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
item_status_cd	An integer that is the unique ID for the item status code.
item_status_desc	A string that is the description of the item status.
color	An integer that indicates the background color for this item status description when displayed in the user interface.
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.

MES Stateless API