GetAll(String,String,Nullable<Int32>,Nullable<Int32>,String,String,Nullable<DateTime>,String) Method
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Overloads Shared Function GetAll( _
ByVal woId As String, _
ByVal operId As String, _
ByVal seqNo As Nullable(Of Integer), _
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 woId As String
Dim operId As String
Dim seqNo 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 modId As String
Dim value As DataSet
value = JobAttr.GetAll(woId, operId, seqNo, attrId, attrValue, lastEditBy, lastEditAt, modId)
public static DataSet GetAll(
string woId,
string operId,
Nullable<int> seqNo,
Nullable<int> attrId,
string attrValue,
string lastEditBy,
Nullable<DateTime> lastEditAt,
string modId
)
Parameters
- woId
- Optional filter parameter. Holds the work order ID of the job whose attributes are being retrieved.
- operId
- Optional filter parameter. Holds the operation ID of the job whose attributes are being retrieved.
- seqNo
- Optional filter parameter. Holds the operation sequence number of the operation whose attributes are being retrieved.
- attrId
- Optional filter parameter. Holds an attribute ID.
- attrValue
- Optional filter parameter. Holds an attribute value.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last updated the attribute record.
- lastEditAt
- Optional filter parameter. Holds a date/time when a record was added or last updated.
- modId
- Optional filter parameter. Holds the current modification ID of a record.
Return Value
Returns a DataSet that contains all the records in the Job_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 |
|---|---|
|
wo_id |
A string that is the work order ID of the job for which this is an attribute. |
|
oper_id |
A string that is the operation ID of the job for which this is an attribute. |
|
seq_no |
An integer that is the operation sequence number of the job for which this is an attribute. |
|
attr_id |
An integer that is the attribute’s ID. |
|
attr_value |
An integer that is the current value of the attribute. |
|
notes |
A string that contains the notes of this attribute. |
|
attr_desc |
A string that is the attribute’s description for the attribute for this job, from the Attr table. This description must be unique within a given attribute group. |
|
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 setting 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 this attribute is visible in the queue, from the Attr table. The default setting is false. This flag can be true only if attr_grp = 1, 5, or 6 , entry_type is 1, and data_type is not 12. |
|
visible_in_inv |
A Boolean that is a flag that indicates whether this attribute is visible in the inventory, from the Attr table. The default setting is false. This flag can be true only if attr_grp=1 or 3, entry_type is not 1, and data_type is not 12. |
|
last_edit_comment |
A string that contains any comments about why record was changed. |
|
last_edit_by |
A string that is the ID of the user that added or last edited this record. |
|
last_edit_at |
A datetime that is the date/time when the record was added or last modified. |
|
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. |