MES Stateless API

GetAll(String,Nullable<Int32>,String,String,String,Nullable<DateTime>) Method

Save PDF

GetAll(String,Nullable<Int32>,String,String,String,Nullable<DateTime>) Method

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAll() method retrieves one or more standard operation attribute records from the Std_Oper_Attr table, as specified by the filter parameters. Passing no filter parameters will retrieve all standard operation attribute records from the table.

This overload of the method includes the attrDescription filter parameter.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal operId As String, _
   ByVal attrId As Nullable(Of Integer), _
   ByVal attrDescription As String, _
   ByVal attrValue As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim operId As String
Dim attrId As Nullable(Of Integer)
Dim attrDescription As String
Dim attrValue As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = StdOperAttr.GetAll(operId, attrId, attrDescription, attrValue, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string operId,
   Nullable<int> attrId,
   string attrDescription,
   string attrValue,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

operId: Optional filter parameter. Holds the ID of the standard operation whose attributes are being retrieved.
attrId: Optional filter parameter. Holds the ID of an attribute.
attrDescription: Optional filter parameter. Holds the description of an attribute.
attrValue: Optional filter parameter. Holds the value of an attribute.
lastEditBy: Optional filter parameter. Holds the ID of a user who added or last updated a standard operation attribute record.
lastEditAt: Optional filter parameter. Holds a date/time when a standard operation attribute record was added or last edited.

Return Value

Returns a DataSet that contains all the records in the Std_Oper_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
oper_ID	A string that is the ID of the operation.
attr_ID	An integer that is the ID of the attribute.
attr_desc	A string that is the attribute description, from the Attr table.
predefined	A Boolean that is a flag that indicates whether the attribute must have a set defined, 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)
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 specifies whether the attribute is to be visible in the queue of jobs, from the Attr table.
visible_in_inv	A Boolean that is a flag that specifies whether the attribute is to be visible in the inventory window, from the Attr table.
attr_value	A string that is the value for this attribute for this operation.
notes	A string that is the notes for this combination of operation and attribute.
last_edit_comment	A string that contains comments about why the record was added or updated.
last_edit_by	A string that is the ID of the user who added or last updated this record.

MES Stateless API