GetAll(String,Nullable<Int32>,String,String,Nullable<DateTime>) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAll() method retrieves one or more standard operation attribute records from the Std_Oper_Attr table, as specified by the filter parameters. Passing no filter parameters will retrieve all standard operation attribute records from the table.
'Declaration
Public Overloads Shared Function GetAll( _
ByVal operId As String, _
ByVal attrId As Nullable(Of Integer), _
ByVal attrValue As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim operId As String
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 = StdOperAttr.GetAll(operId, attrId, attrValue, lastEditBy, lastEditAt)
public static DataSet GetAll(
string operId,
Nullable<int> attrId,
string attrValue,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- operId
- Optional filter parameter. Holds the ID of the standard operation whose attributes 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 added or last updated a standard operation attribute record.
- lastEditAt
- Optional filter parameter. Holds a date/time when a standard operation attribute record was added or last edited.
Return Value
Returns a DataSet that contains all the records in the Std_Oper_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 |
|---|---|
|
oper_ID |
A string that is the ID of the operation. |
|
attr_ID |
An integer that is the ID of the attribute. |
|
attr_desc |
A string that is the attribute description, from the Attr table. |
|
predefined |
A Boolean that is a flag that indicates 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 to be 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 to be visible in the inventory window, from the Attr table. |
|
attr_value |
A string that is the value for this attribute for this operation. |
|
notes |
A string that is the notes for this combination of operation and attribute. |
|
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. |