MES Stateless API

GetAll Method (OperEntSpec)

Save PDF

GetAll Method (OperEntSpec)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal processId As String, _
   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 grpId As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim processId As String
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 grpId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = OperEntSpec.GetAll(processId, operId, stepNo, entId, verId, specId, grpId, lastEditBy, lastEditAt)

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

Parameters

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.
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.
grpId: Optional filter parameter. Holds the ID of a specification group.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated an operation entity specification record.
lastEditAt: Optional filter parameter. Holds the date/time when an operation entity specification record was added or last updated.

Return Value

Returns a DataSet that contains records for all the operation entity specification that satisfy the specified filters. The returned records include columns from the Spec and Oper_Ent_Spec tables. If no matching operation entity 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.
ent_id	An integer that is the ID of the entity.
ver_id	A string that is the version ID of the specification.
spec_id	A string 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 of which this specification is a member, from the Spec table.
assoc_file	A string that is the path and file name of the file associated with this specification.
assoc_file_type	A string that is the file type of the file that is associated with this specification.
comments	A string containing the comments or instructions to operator regarding this 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.
ent_name	A string that is entity name.
process_desc	A string that is 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.
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.
data_type	An integer that is an enumeration that indicates the data type of the specification value. 0 = string (the default) 1 = floating point number

MES Stateless API