GetAll(Nullable<Int32>,Nullable<Int32>,String,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Overloads Shared Function GetAll( _
ByVal sampleId As Nullable(Of Integer), _
ByVal attrId As Nullable(Of Integer), _
ByVal attrValue As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim sampleId As Nullable(Of Integer)
Dim attrId As Nullable(Of Integer)
Dim attrValue As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = SampleAttr.GetAll(sampleId, attrId, attrValue, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> sampleId,
Nullable<int> attrId,
string attrValue,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- sampleId
- Optional filter parameter. Holds the sample ID.
- attrId
- Optional filter parameter. Holds the attribute ID.
- attrValue
- Optional filter parameter. Holds the value of the attribute.
- lastEditBy
- Optional filter parameter. Holds the name of the user who added or last changed an entity record.
- lastEditAt
Optional filter parameter. Holds a date/time of when an entity record was added or last changed.
Return Value
Returns a DataSet that contains records from the Sample_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 |
|---|---|
|
sample_id |
An integer that is the ID of the sample to which the attribute applies. |
|
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 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, the item attribute group) 12 = long string (> 80 characters)integer that identifies the data type for the attribute |
|
entry_type |
An integer that is 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 integer that indicates the type of entry to allow for this attribute |
|
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 this 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. |