MES Stateless API

GetAll Method (CertStdOperLink)

Save PDF

GetAll Method (CertStdOperLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal certName As String, _
   ByVal operId As String, _
   ByVal certLevel As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim certName As String
Dim operId As String
Dim certLevel As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = CertStdOperLink.GetAll(certName, operId, certLevel, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string certName,
   string operId,
   Nullable<int> certLevel,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

certName: Optional filter parameter. Holds the name of the certification.
operId: Optional filter parameter. Holds the ID of the standard operation.
certLevel: Optional filter parameter. Holds the certification level.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated an certification/standard operation link record.
lastEditAt: Optional filter parameter. Holds the date/time when a certification/standard operation link record was added or last updated.

Return Value

Returns a DataSet that contains records for all the certification/standard operation links that satisfy the specified filters. The returned records include columns from the Cert_Std_Oper_Link, Cert_Type, and Std_Oper tables. If no matching certification/standard operation links are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

ColumnName	Description
cert_name	A string that is the name of the certification linked to the standard operation.
oper_id	A string that is the ID of the standard operation linked to the certification.
cert_level	An integer that is the certification level required to access the operation.
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.
max_level	An integer that is the maximum value that can be entered in the cert_level field, from the Cert_Type table.
cert_audit	An flag that indicates whether or not the certification is an audit certification, from the Cert_Type table.
oper_desc	An string that is the description of the operation, from the Oper table.

MES Stateless API