MES Stateless API

GetAll(String,String,Nullable<Int32>,String,String,String,Nullable<DateTime>,String) Method

Save PDF

GetAll(String,String,Nullable<Int32>,String,String,String,Nullable<DateTime>,String) Method

Save PDF

Last UpdatedNov 06, 2025
3 minute read

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

This overload of the method includes the attrDescription filter parameter.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal attrId As Nullable(Of Integer), _
   ByVal attrDescription As String, _
   ByVal attrValue As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date), _
   ByVal modId As String _
) As DataSet

'Usage
 
Dim itemId As String
Dim lotNo As String
Dim attrId As Nullable(Of Integer)
Dim attrDescription As String
Dim attrValue As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim modId As String
Dim value As DataSet
 
value = LotAttr.GetAll(itemId, lotNo, attrId, attrDescription, attrValue, lastEditBy, lastEditAt, modId)

public static DataSet GetAll( 
   string itemId,
   string lotNo,
   Nullable<int> attrId,
   string attrDescription,
   string attrValue,
   string lastEditBy,
   Nullable<DateTime> lastEditAt,
   string modId
)

Parameters

itemId: Optional filter parameter. Holds the item ID of the lots whose attributes are being retrieved.
lotNo: Optional filter parameter. Holds the number of the lot whose attributes are being retrieved.
attrId: Optional filter parameter. Holds the ID of the attribute.
attrDescription: Optional filter parameter. Holds the description of the attribute.
attrValue: Optional filter parameter. Holds the value of the attribute instance for the lot.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last changed the record.
lastEditAt: Optional filter parameter. Holds the date/time when the record was added or last updated.
modId: Optional filter parameter. Holds the modification ID assigned to this record.

Return Value

Returns a DataSet that contains records for all the lot attributes that satisfy the specified filters. The returned records include columns from the Item, Attr, Lot, and Lot_Attr tables. If no matching lot attributes are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Names	Description
item_id	A string that is the ID of the item, from the Lot table.
lot_no	A string that is the lot number, from the Lot table.
attr_id	An integer that is the ID of the attribute, from the Attr table.
attr_desc	A string that is the description of the attribute, from the Attr table.
predefined	A Boolean that is a flag that specifies whether the attribute is defined, from the Attr table.
data_type	An integer that is an enumeration that indicates the data type of the attribute, from the Attr table. 0 = string (<= 80 characters; the default data type) 1 = drop-down list of values defined in the Attr_Set table 2 = integer 3 = currency 4 = color 5 = datetime 6 = floating point number 7 = percent 8 = check box 9 = non-editable 10 = time of day 11 = item reason (only if attr_grp = 3) 12 = long string (> 80 characters)
entry_type	An enumeration that indicates the type of entry to allow for this attribute, from the Attr table. 0 = value only (the default) 1 = notes only 2 = value and notes
visible_in_queue	A Boolean that is a flag that specifies whether the attribute is visible in the queue of jobs, from the Attr table.
visible_in_inv	A Boolean that is a flag that specifies whether the attribute is visible in the inventory, from the Attr table.
item_desc	A string that is the description of the item, from the Item table.
attr_value	A string that is the attribute value, from the Lot_Attr table.
notes	A string that contains notes of this attribute in this instance associated with this lot, from the Lot_Attr 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 date/time that indicates when the record was added or last updated.

MES Stateless API