MES Stateless API

GetAll Method (CertType)

Save PDF

GetAll Method (CertType)

Save PDF

Last UpdatedNov 06, 2025
6 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal certName As String, _
   ByVal maxLevel As Nullable(Of Integer), _
   ByVal audit As Nullable(Of Boolean), _
   ByVal duration As Nullable(Of Integer), _
   ByVal availToOperations As Nullable(Of Boolean), _
   ByVal availToOperationSteps As Nullable(Of Boolean), _
   ByVal availToProducingItems As Nullable(Of Boolean), _
   ByVal availToConsumingItems As Nullable(Of Boolean), _
   ByVal availToAttributes As Nullable(Of Boolean), _
   ByVal availToGradeChange As Nullable(Of Boolean), _
   ByVal availToStateChange As Nullable(Of Boolean), _
   ByVal availToLogData As Nullable(Of Boolean), _
   ByVal uptoExperimental As Nullable(Of Boolean), _
   ByVal uptoApproved As Nullable(Of Boolean), _
   ByVal uptoCertified As Nullable(Of Boolean), _
   ByVal downToDisabled As Nullable(Of Boolean), _
   ByVal downToExperimental As Nullable(Of Boolean), _
   ByVal downToApproved As Nullable(Of Boolean), _
   ByVal spare1 As String, _
   ByVal spare2 As String, _
   ByVal spare3 As String, _
   ByVal spare4 As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim certName As String
Dim maxLevel As Nullable(Of Integer)
Dim audit As Nullable(Of Boolean)
Dim duration As Nullable(Of Integer)
Dim availToOperations As Nullable(Of Boolean)
Dim availToOperationSteps As Nullable(Of Boolean)
Dim availToProducingItems As Nullable(Of Boolean)
Dim availToConsumingItems As Nullable(Of Boolean)
Dim availToAttributes As Nullable(Of Boolean)
Dim availToGradeChange As Nullable(Of Boolean)
Dim availToStateChange As Nullable(Of Boolean)
Dim availToLogData As Nullable(Of Boolean)
Dim uptoExperimental As Nullable(Of Boolean)
Dim uptoApproved As Nullable(Of Boolean)
Dim uptoCertified As Nullable(Of Boolean)
Dim downToDisabled As Nullable(Of Boolean)
Dim downToExperimental As Nullable(Of Boolean)
Dim downToApproved As Nullable(Of Boolean)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = CertType.GetAll(certName, maxLevel, audit, duration, availToOperations, availToOperationSteps, availToProducingItems, availToConsumingItems, availToAttributes, availToGradeChange, availToStateChange, availToLogData, uptoExperimental, uptoApproved, uptoCertified, downToDisabled, downToExperimental, downToApproved, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string certName,
   Nullable<int> maxLevel,
   Nullable<bool> audit,
   Nullable<int> duration,
   Nullable<bool> availToOperations,
   Nullable<bool> availToOperationSteps,
   Nullable<bool> availToProducingItems,
   Nullable<bool> availToConsumingItems,
   Nullable<bool> availToAttributes,
   Nullable<bool> availToGradeChange,
   Nullable<bool> availToStateChange,
   Nullable<bool> availToLogData,
   Nullable<bool> uptoExperimental,
   Nullable<bool> uptoApproved,
   Nullable<bool> uptoCertified,
   Nullable<bool> downToDisabled,
   Nullable<bool> downToExperimental,
   Nullable<bool> downToApproved,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

certName

Optional filter parameter. Holds the name of the certification.

maxLevel

Optional filter parameter. Holds the maximum level of the certification.

audit

Optional filter parameter. Holds a flag that indicates whether the certification requires an audit.

duration

Optional filter parameter. Holds the number of days that the certification is valid (0 = permanent).

availToOperations

Optional filter parameter. Holds a flag that indicates whether the certification can be applied to operations.

availToOperationSteps

Optional filter parameter. Holds a flag that indicates whether the certification can be applied to operation steps.

availToProducingItems

Optional filter parameter. Holds a flag that indicates whether the certification can be applied to producing items.

availToConsumingItems

Optional filter parameter. Holds a flag that indicates whether the certification can be applied to consuming items.

availToAttributes

Optional filter parameter. Holds a flag that indicates whether the certification can be applied to editing attributes.

Note: Applying certifications to attributes is not currently supported.

availToGradeChange

Optional filter parameter. Holds a flag that indicates whether the certification can be applied to item grade changes.

Note: Applying certifications to item grade changes is not currently supported.

availToStateChange

Optional filter parameter. Holds a flag that indicates whether the certification can be applied to item state changes.

Note: Applying certifications to item state changes is not currently supported.

availToLogData

Optional filter parameter. Holds a flag that indicates whether the certification can be applied to logging data.

uptoExperimental

Optional filter parameter. Holds a flag that indicates whether the certification is needed to increase the status of a process to experimental.