MES Stateless API

GetAttrs Method (WOAttr)

Save PDF

GetAttrs Method (WOAttr)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAttrs() method retrieves the attribute records for the specified work order from the WO_Attr table.

Syntax

'Declaration
 
Public Shared Function GetAttrs( _
   ByVal woId As String, _
   ByVal userId As String _
) As DataSet

'Usage
 
Dim woId As String
Dim userId As String
Dim value As DataSet
 
value = WOAttr.GetAttrs(woId, userId)

public static DataSet GetAttrs( 
   string woId,
   string userId
)

Parameters

woId: Required. A string which identifies the work order whose attributes are being retrieved.
userId: Required. A string that identifies a user whose certification level must be >= the certification level of the attribute.

Return Value

Returns a DataSet that contains records for all the work order's attributes. The returned records include columns from the Attr and Wo_Attr table. If no matching records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Names	Description
wo_id	A string that is the ID of the work order, from the WO_Attr table.
attr_id	An integer that is the ID of the attribute, from the WO_Attr table.
attr_desc	An integer that is the description of the attribute, from the 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) This list might be extended in future releases.
attr_grp	An integer that is the attribute group, from the Attr table.
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.
visible_in_inv	A Boolean that is a flag that indicates whether this attribute is visible in the inventory, from the Attr table.
attr_value	An integer that is the current value of the attribute for this work order, from the WO_Attr table.
notes	A string that contains any notes for this attribute, from the WO_Attr table
last_edit_comment	A string that contains comments about why the record was changed, from the WO_Attr table.
last_edit_by	A string that is the ID of the user who added or last updated this record, from the WO_Attr table.
last_edit_at	A date/time that indicates when the record was added or last updated.
editable	A Boolean that is a flag that indicates whether or not this attribute can be edited. This will be set to false if certifications are attached to the attribute and the user does not have all the certifications at the required level.
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 WO_Attr table.

MES Stateless API

GetAttrs Method (WOAttr)

Table of Contents

GetAttrs Method (WOAttr)

In This Topic

MES Stateless API

GetAttrs Method (WOAttr)

Syntax

Parameters

Return Value

See Also

Reference

In This Topic