GetAttrs Method (JobAttr)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAttrs() method retrieves all attributes that are assigned to the specified job and also indicates whether the specified user has permission to edit the attribute.
Parameters
- woId
- Required. Holds the work order ID of the job whose attribute records are being retrieved.
- operId
- Required. Holds the operation ID of the job whose attribute records are being retrieved.
- seqNo
- Required. Holds the operation sequence number of the operation whose attribute records 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 records for all the job attribute records that satisfy the specified filters. The returned records include columns from the Attr and Job_Attr tables. If no matching attribute records are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
Column |
Description |
|---|---|
|
wo_id |
A string that is the ID of the work order to which the job belongs. |
|
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 ID of the attribute assigned to the job. |
|
attr_desc |
A string that is the description of the attribute assigned to the job, 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) |
|
predefined |
A Boolean that is a flag that specifies whether the attribute has predefined values in the Attr_Set table, 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 |
|
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, from the Attr table. |
|
visible_in_queue |
A Boolean that is a flag that specifies whether the attribute is visible in the queue, from Attr table. |
|
visible_in_inv |
A Boolean that is a flag that specifies whether the attribute is visible in the inventory, from Attr table. |
|
attr_value |
An integer that is the value of the attribute. |
|
notes |
A string that is the notes for the attribute |
|
last_edit_comment |
A string that contains comments about why the record was added or updated. |
|
last_edit_by |
A string to identify the user that last edited this record. |
|
last_edit_at |
A date/time which identifies when the record was created or last modified at. |
| editable | A Boolean that is a flag that indicates whether the attribute is editable. The attribute will be editable if there are no certifications associated with the attribute or if the user has the correct level for all the certifications associated with the attribute. |
| 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. |