GetAll(String,Nullable<Int32>,String,String,String,Nullable<DateTime>,String) Method
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Overloads Shared Function GetAll( _
ByVal itemId As String, _
ByVal attrId As Nullable(Of Integer), _
ByVal attrValue As String, _
ByVal notes As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal modId As String _
) As DataSet
'Usage
Dim itemId As String
Dim attrId As Nullable(Of Integer)
Dim attrValue As String
Dim notes As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim modId As String
Dim value As DataSet
value = ItemAttr.GetAll(itemId, attrId, attrValue, notes, lastEditBy, lastEditAt, modId)
public static DataSet GetAll(
string itemId,
Nullable<int> attrId,
string attrValue,
string notes,
string lastEditBy,
Nullable<DateTime> lastEditAt,
string modId
)
Parameters
- itemId
- Optional filter parameter. Holds the ID of an item whose attribute records are being retrieved.
- attrId
- Optional filter parameter. Holds the ID of an attribute.
- attrValue
- Optional filter parameter. Holds the value of an attribute.
- notes
- Optional filter parameter. Holds the notes for an attribute.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who created or last updated an item attribute record.
- lastEditAt
- Optional filter parameter. Holds the date and time when an item attribute record was created or last updated.
- modId
- Optional filter parameter. Holds the modification ID assigned to an item attribute record.
Return Value
Returns a DataSet that contains all the records in the Item_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 Name |
Description |
|---|---|
|
item_id |
A string that is the ID of the item to which the attribute applies. |
|
item_desc |
A string that is the description of the item to which the attribute applies, from the item.item_desc column in the Item table linked to this item_id. |
|
attr_id |
An integer that is the attribute 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. |
|
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 link 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. |
|
last_edit_comment |
A string that holds any comments about why record was added or last 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 is when the record was added or last updated. |
|
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. |