GetAvailableAttrs Method (WOAttr)
- Last UpdatedNov 06, 2025
- 2 minute read
Parameters
- woId
- Required. Holds the ID of the work order whose available attributes are being retrieved.
- userId
- Required. Holds the ID of a user whose certification level must be at the certification level of the attribute or greater.
Return Value
Returns a DataSet that contains the records in the Attr table of all attributes that are available for the specified work order. If no matching records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column Name |
Description |
|---|---|
|
attr_id |
An integer that is the ID of the attribute, from the WO_Attr table. |
|
predefined |
A Boolean that is a flag that indicates whether the work order attribute's values come from 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) |
|
attr_desc |
A string that is the description of the attribute, from the Attr table. |
|
attr_grp |
An integer that is an enumeration that indicates the group to which the attribute belongs, from the Attr table. 1 = Items 2 = Entities 3 = Lots 4 = Item Classes 5 = Jobs 6 = WO 7 = Operations 8 = Processes 9 = Sublot 10 = Samples 11 = Results 12 = Lines 13 = Shifts |
|
filtr |
Not used for work order attributes. |
|
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 |
|
last_edit_comment |
A string that contains comments about why the record was changed. |
|
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 specifies when the record was added or last updated. |
The list of available work order attributes is retrieved from the Attr table based on the following criteria:
- The attribute must belong to work order group (attr_grp = 6).
- If the attribute has a certification attached to it, the supplied user must have this certification, at a level that is equal to or greater than the required certification level, or no users have this certification.
- All attributes that are currently assigned to the supplied work order are excluded from the DataSet.