MES Stateless API

GetAll Method (OperItemSpec)

Save PDF

GetAll Method (OperItemSpec)

Save PDF

Last UpdatedNov 06, 2025
4 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal rowId As Nullable(Of Integer), _
   ByVal processId As String, _
   ByVal operId As String, _
   ByVal stepNo As Nullable(Of Integer), _
   ByVal itemId As String, _
   ByVal itemClassId As String, _
   ByVal verId As String, _
   ByVal specId As String, _
   ByVal grpId As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim rowId As Nullable(Of Integer)
Dim processId As String
Dim operId As String
Dim stepNo As Nullable(Of Integer)
Dim itemId As String
Dim itemClassId As String
Dim verId As String
Dim specId As String
Dim grpId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = OperItemSpec.GetAll(rowId, processId, operId, stepNo, itemId, itemClassId, verId, specId, grpId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> rowId,
   string processId,
   string operId,
   Nullable<int> stepNo,
   string itemId,
   string itemClassId,
   string verId,
   string specId,
   string grpId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

rowId: Optional filter parameter. Holds the unique row ID that was assigned to an operation item specification record when it is added.
processId: Optional filter parameter. Holds the ID of a process.
operId: Optional filter parameter. Holds the ID of an operation.
stepNo: Optional filter parameter. Holds a step number.
itemId: Optional filter parameter. Holds the ID of an item.
itemClassId: Optional filter parameter. Holds the ID of an item class.
verId: Optional filter parameter. Holds a specification version.
specId: Optional filter parameter. Holds a specification ID.
grpId: Optional filter parameter. Holds the ID of the specification group of which a specification is a member.
lastEditBy: Optional filter parameter. The ID of a user who created or last modified an operation item specification record.
lastEditAt: Optional filter parameter. Holds the date/time when an operation item specification record was added or last updated

Return Value

Returns a DataSet that contains records for all the operation item specifications that satisfy the specified filters. The returned records include columns from the Spec and Oper_Item_Spec tables. If no matching operation item specification records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

ColumnName	Description
process_id	A string that is the ID of the process.
oper_id	A string that is the ID of the operation.
step_no	An integer that is the step number. The default is -1, which means that the specification is not associated with a step.
item_id	An integer that is the ID of the item.
item_class_id	An integer that is the ID of the item class.
ver_id	A string that is the version ID of the specification.
spec_id	A string value that is the ID of the specification.
spec_value	A string that is the specification value.
grp_id	A string that is the ID of the specification group to which the specification belongs. From the Spec table.
assoc_file	A string that is the path and file name of the file associated with the specification.
assoc_file_type	A string that is the file type of the file associated with the specification.
comments	A string that is the comments or instructions for an operator regarding the specification.
min_value	A string that is the minimum acceptable value for the specification. The default is null, which means no minimum value is defined.
max_value	A string that is the maximum acceptable value for the specification. The default is null, which means no maximum value is defined.
access_level	An integer that is the security access level for modifying this specification. The default is null, which means that no extra security is defined.
process_desc	A string that is the process description.
spec_desc	A string that is the description of the specification. From the Spec table.
units	A string that is the unit of measure for the specification value.
spare1	A string that is the contents of the user-defined spare1 field.
spare2	A string that is the contents of the user-defined spare2 field.
spare3	A string that is the contents of the user-defined spare3 field.
spare4	A string that is the contents of the user-defined spare4 field.
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.
last_edit_at	A date and time that indicates when the record was added or last updated.
data_type	An integer that is an enumeration that indicates the data type of the specification value. From the Spec table. 0 = string (the default) 1 = floating point number

MES Stateless API