GetAll(String,Nullable<Int32>,String,String,Nullable<DateTime>,String) Method
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAll() method retrieves one or more process attribute records from the Process_Attr table, as specified by the filter parameters. Passing no filter parameters will retrieve all process attribute records from the table.
'Declaration
Public Overloads Shared Function GetAll( _
ByVal processId As String, _
ByVal attrId As Nullable(Of Integer), _
ByVal attrValue As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal modId As String _
) As DataSet
'Usage
Dim processId As String
Dim attrId As Nullable(Of Integer)
Dim attrValue As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim modId As String
Dim value As DataSet
value = ProcessAttr.GetAll(processId, attrId, attrValue, lastEditBy, lastEditAt, modId)
public static DataSet GetAll(
string processId,
Nullable<int> attrId,
string attrValue,
string lastEditBy,
Nullable<DateTime> lastEditAt,
string modId
)
Parameters
- processId
- Optional filter parameter. Holds the ID of the process whose attributes are being retrieved.
- attrId
- Optional filter parameter. Holds the ID of the attribute.
- attrValue
- Optional filter parameter. Holds an attribute value.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last updated the record.
- lastEditAt
- Optional filter parameter. Holds a date/time when the record was added or last edited.
- modId
- Optional filter parameter. Holds the modification ID assigned the last time this record was added or updated, for optimistic concurrency control.
Return Value
Returns a DataSet that contains the records in the Process_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 |
|---|---|
|
process_id |
A string that is the ID of the attribute’s process. |
|
attr_id |
An integer that is the ID of the attribute. |
|
attr_value |
A string that is the current value of the attribute for this process. |
|
notes |
A string that is the notes of the attribute for this process. |
|
attr_desc |
A string that is the description of the attribute, from the Attr table. The description must be unique within a given attr_grp. |
|
predefined |
A Boolean that is a flag that indicates whether the attribute must be assigned from a predefined set of values, from the Attr table. The default is false. |
|
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 indicates whether the attribute is visible in the queue of jobs, from the Attr table. The default is false. |
|
visible_in_inv |
A Boolean that is a flag that indicates whether the attribute is visible in the inventory, from the Attr table. The default is false. |
|
last_edit_comment |
A string that contains comments about why record was changed, from the Process table. |
|
last_edit_by |
A string that is the ID of the user that last edited this record, from the Process table. |
|
last_edit_at |
A datetime that specifies when the record was added or last modified, from the Process table. |
|
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. From the Process table. |