MES Stateless API

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

Save PDF

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

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAll() method retrieves one or more sublot attribute records from the Sublot_Attr table, as specified by the filter parameters. Passing no filter parameters will retrieve all sublot 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 subLotNo 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) _
) As DataSet

'Usage
 
Dim itemId As String
Dim lotNo As String
Dim subLotNo 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 value As DataSet
 
value = SubLotAttr.GetAll(itemId, lotNo, subLotNo, attrId, attrDescription, attrValue, lastEditBy, lastEditAt)

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

Parameters

itemId: Optional filter parameter. Holds the ID of the item of the lot to which a sublot belongs.
lotNo: Optional filter parameter. Holds the lot number of the lot to which the sublot belongs.
subLotNo: Optional filter parameter. Holds the number of the sublot whose attributes are being retrieved.
attrId: Optional filter parameter. Holds the ID of the attribute to be retrieved.
attrDescription: Optional filter parameter. Holds the description of the attribute to be retrieved.
attrValue: Optional filter parameter. Holds the value of the attribute.
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. This filter retrieves all records with a datetime that is greater than or equal to the value specified.

Return Value

Returns a DataSet that contains all the records in the Sublot_Attr 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 Names	Description
item_id	A string that is the ID of the item of the lot that the sublot is a part of.
lot_no	A string that is the lot number that this sublot is a part of.
sublot_no	A string that is the sublot number.
attr_id	An integer that is the ID of the attribute.
attr_value	A string that is the value of this attribute as it is associated with this sublot.
notes	A string that contains the notes of this attribute in this instance associated with this sublot.
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