MES Stateless API

GetAttrs Method (LotAttr)

Save PDF

GetAttrs Method (LotAttr)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAttrs() method retrieves all attributes that are assigned to the specified lot and also indicates whether the specified user has permission to edit the attribute.

Syntax

'Declaration
 
Public Shared Function GetAttrs( _
   ByVal itemId As String, _
   ByVal lotNo As String, _
   ByVal userId As String _
) As DataSet

'Usage
 
Dim itemId As String
Dim lotNo As String
Dim userId As String
Dim value As DataSet
 
value = LotAttr.GetAttrs(itemId, lotNo, userId)

public static DataSet GetAttrs( 
   string itemId,
   string lotNo,
   string userId
)

Parameters

itemId: Required. Holds the item ID of the lots whose attributes are being retrieved.
lotNo: Required. Holds the number of the lot whose attributes are being retrieved.
userId: Required. Holds the ID of a user whose certification level must be at the certification level of the attribute or greater.

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 Attr 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_Attr table.
lot_no	A string that is the lot number, from the Lot_Attr table.
attr_id	An integer that is the ID of the attribute, from the Lot_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 must have a set 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 inventory, from the Attr table.
attr_value	A string that is the value of this attribute as it is associated with this lot, from the Lot_Attr table.
notes	A string that contains notes of this attribute in the 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.
editable	A Boolean that is a flag that indicates whether the attribute is editable. The attribute will be editable if there are no certifications associated with the attribute or if the user has the correct level for all the certifications associated with the attribute.
mod_id	The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes.
filtr	A string that specifies the special situation that affects when this attribute may be used, from the Attr table.

MES Stateless API

GetAttrs Method (LotAttr)

Table of Contents

GetAttrs Method (LotAttr)

In This Topic

MES Stateless API

GetAttrs Method (LotAttr)

Syntax

Parameters

Return Value

Remarks

See Also

Reference

In This Topic