MES Stateless API

GetAll Method (StdOperEntSpec)

Save PDF

GetAll Method (StdOperEntSpec)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

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

Syntax

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

'Usage
 
Dim operId As String
Dim stepNo As Nullable(Of Integer)
Dim entId As Nullable(Of Integer)
Dim verId As String
Dim specId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = StdOperEntSpec.GetAll(operId, stepNo, entId, verId, specId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string operId,
   Nullable<int> stepNo,
   Nullable<int> entId,
   string verId,
   string specId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

operId: Optional filter parameter. Holds the ID of the standard operation.
stepNo: Optional filter parameter. Holds the number of the step with which a specification is associated. -1 means the specification is not associated with a step.
entId: Optional filter parameter. Holds the ID of an entity.
verId: Optional filter parameter. Holds a specification version.
specId: Optional filter parameter. Holds the ID of a specification.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated the record.
lastEditAt: Optional filter parameter. Holds a date/time when the record was added or last edited.

Return Value

Returns a DataSet that contains records for all the standard operation specifications that satisfy the specified filters. The returned records include columns from the Ent, Spec, and Std_Oper_Ent_Spec tables. If no matching standard operation specifications 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.
step_no	An integer that is the step number assoiciated with this specification. The default is -1 (not associated with a step).
ent_id	An integer that is the ID of the entity.
ver_id	A string that is the specification version.
spec_id	A string that is the specification ID.
spec_value	A string that is the specification value.
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 contains the comments or instructions for the operator regarding this specification.
min_value	A string that is the minimum acceptable value for the specification. The default is null, which means that no minimum value is defined.
max_value	A string that is the maximum acceptable value for the specification. The default is null, which means that 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.
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/time that indicates when the record was added or last updated.
row_id	An integer that is the unique ID of the row.
ent_name	A string that is the name of the entity, from the Ent table.
spec_desc	A string that is the description of the specification, from the Spec table.
grp_id	A string that is the ID of the specification group of which this specification is a member, from the Spec table.
units	A string that is the unit of measure for the specification value, from the Spec table.
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.
data_type	An integer that is an enumeration that indicates the data type of the specification, from the Spec table. 0 = string (the default) 1 = floating point number

MES Stateless API