GetLotSubLotByFilter Method
- Last UpdatedNov 06, 2025
- 2 minute read
'Declaration
Public Shared Function GetLotSubLotByFilter( _
ByVal itemClassId As String, _
ByVal itemId As String, _
ByVal lotNo As String, _
ByVal subLotNoFilter As String _
) As DataSet
public static DataSet GetLotSubLotByFilter(
string itemClassId,
string itemId,
string lotNo,
string subLotNoFilter
)
Parameters
- itemClassId
- Optional filter parameter. Holds the id of the item class that the item of the lot belongs to.
- itemId
- Optional filter parameter. Holds the id of the item of the lot.
- lotNo
- Optional filter parameter. Holds the identifier of the lot.
- subLotNoFilter
- Optional filter parameter. Holds the sublot number identifier.
Return Value
Returns a DataSet that contains records for all the lots that satisfy the specified filters. The returned records include columns from the Sublot, Lot, Item, and Item_Class tables. If no matching lots 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 that is stored, from the Lot table. |
|
lot_no |
A string that is lot number, from the Lot table. |
|
grade_cd |
An integer that is grade code of the lot, from the Lot table. |
|
status_cd |
An integer that is the status code of the lot, from the Lot table. |
|
expiry_date |
A datetime that is the lot's expiry date and time, from the Lot table. This is a fixed time that is not related to a local time or UTC. Note: This parameter is not currently used by the system. |
|
is_serial_no |
A Boolean that is a flag that specifies whether the lot is the serial number, from the Lot table. |
|
sublot_no |
A string that is a sublot number, from the Sublot table. |
|
parent |
A string that is a parent lot or a sublot, from the Sublot table. |
|
lvl |
An integer that is the level of the sublot, from the Sublot table. It is 1 if the parent is a lot and greater than 1 if the parent is a sublot. |
|
item_desc |
A string that is the description of the item, from the Item table. |
|
item_class_id |
A string that is the ID of the item class, from the Item_Class table. |
|
item_class_desc |
A string that is the description of the item class, from the Item table. |