MES Stateless API

GetAll Method (OperSpecVer)

Save PDF

GetAll Method (OperSpecVer)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal processId As String, _
   ByVal operId As String, _
   ByVal verId As String, _
   ByVal verDate As Nullable(Of Date), _
   ByVal preferredVer As Nullable(Of Boolean), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim processId As String
Dim operId As String
Dim verId As String
Dim verDate As Nullable(Of Date)
Dim preferredVer As Nullable(Of Boolean)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = OperSpecVer.GetAll(processId, operId, verId, verDate, preferredVer, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string processId,
   string operId,
   string verId,
   Nullable<DateTime> verDate,
   Nullable<bool> preferredVer,
   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.
verId: Optional filter parameter. Holds the ID of a specification version.
verDate: Optional filter parameter. Holds the date and time when a record was created or last modified, in UTC.
preferredVer: Optional filter parameter. Holds a flag that indicates this is a preferred version.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated an operation specification version record.
lastEditAt: Optional filter parameter. Holds the date and time when an operation specification version record was added or last updated.

Return Value

Returns a DataSet that contains records for all the operation specification version that satisfy the specified filters. The returned records include columns from the Process and Oper_Spec_Ver tables. If no matching operation specification versions are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
process_id	A string that is the ID of the process.
oper_id	A string that is the ID of the operation.
ver_id	A string that is the ID of the specification version.
ver_date	A string that is the date and time when the specification version was created or last modified, in UTC.
ver_comments	A string that contains the comments for this version.
preferred_ver	A Boolean that is a flag that specifies this is the preferred version.
process_desc	A string that is the description of the process, from the Process table.
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.

MES Stateless API