GetAttrs Method (ItemClassAttr)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAttrs( _
ByVal itemClassId As String, _
ByVal userId As String _
) As DataSet
'Usage
Dim itemClassId As String
Dim userId As String
Dim value As DataSet
value = ItemClassAttr.GetAttrs(itemClassId, userId)
public static DataSet GetAttrs(
string itemClassId,
string userId
)
Parameters
- itemClassId
- Required. Holds the ID of the item class for which a list of attributes is being requested.
- userId
- Required. Holds the ID of the user requesting the list of attributes.
Return Value
Returns a DataSet that contains records for all the item class attribute records that satisfy the specified filters. The returned records include columns from the Attr and Item_Class_Attr tables. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
item_class_id |
A string that is the ID of the item class to which the attribute applies. |
|
attr_id |
An integer that is the attribute ID. |
|
attr_desc |
A string that is the description of the attribute, from the attr_desc column of the Attr table linked by the attr_id. |
|
predefined |
A Boolean that is a flag that specifies whether the attribute has a defined set of values in the attr_set table. |
|
data_type |
An integer that is an enumeration that indicates the data type of the attribute, from the data_type column of the Attr table linked by the attr_id. 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 entry_type column in the Attr table linked by the attr_id. 0 = value only (the default) 1 = notes only 2 = value and notes |
|
visible_in_queue |
A Boolean that is a flag that specifies whether this attribute is visible in the queue, from the visible_in_queue column of the Attr table linked by the attr_id. |
|
visible_in_inv |
A Boolean that is a flag that specifies whether this attribute is visible in the inventory, from the visible_in_inv column of the Attr table linked by the attr_id. |
|
item_class_desc |
A string that is the description of the item class to which the attribute applies, from the item_class.item_class_desc column in the Item_Class table linked to this item_class_id. |
|
attr_value |
A string that is the value for this attribute. The contents of this field depend on the data type specified in the data_type column. |
|
notes |
A string that is any notes for this attribute. |
|
last_edit_comment |
A string that is any comments about why 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. |
|
editable |
A Boolean that is a flag that specifies 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. |