GetAll(Nullable<Int32>,Nullable<Int32>,String,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Overloads Shared Function GetAll( _
ByVal shiftId 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 shiftId 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 = ShiftAttr.GetAll(shiftId, attrId, attrValue, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> shiftId,
Nullable<int> attrId,
string attrValue,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- shiftId
- Optional filter parameter. Holds the ID of a shift 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.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who created or last updated a shift attribute record.
- lastEditAt
- Optional filter parameter. Holds the date and time when a shift attribute record was created or last updated.
Return Value
Returns a DataSet that contains all the records in the Shift_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 |
|---|---|
|
shift_id |
An integer that is the ID of the shift to which the attribute applies. |
|
shift_desc |
A string that is the description of the shift to which the attribute applies. From the shift_desc column in the Shift table linked to this shift_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 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 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 |
|
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. |
|
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. |