MES Stateless API

UpdateSpecific Method (CertType)

Save PDF

UpdateSpecific Method (CertType)

Save PDF

Last UpdatedNov 06, 2025
5 minute read

The UpdateSpecific() method updates selected columns of the specified certification type record in the Cert_Type table.

Syntax

'Declaration
 
Public Shared Sub UpdateSpecific( _
   ByVal sessionId As Integer, _
   ByVal certName As String, _
   ByVal maxLevel As Nullable(Of Integer), _
   ByVal audit As Nullable(Of Boolean), _
   ByVal duration As Nullable(Of Integer), _
   ByVal hoursToRenew 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 totalSignOffsRequired As DBInt, _
   ByVal requireSignOffComments As Nullable(Of Boolean), _
   ByVal signoffNotes As DBString, _
   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 DBString, _
   ByVal spare2 As DBString, _
   ByVal spare3 As DBString, _
   ByVal spare4 As DBString, _
   ByVal lastEditComment As DBString, _
   ByRef lastEditAt As Nullable(Of Date) _
)

'Usage
 
Dim sessionId As Integer
Dim certName As String
Dim maxLevel As Nullable(Of Integer)
Dim audit As Nullable(Of Boolean)
Dim duration As Nullable(Of Integer)
Dim hoursToRenew 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 totalSignOffsRequired As DBInt
Dim requireSignOffComments As Nullable(Of Boolean)
Dim signoffNotes As DBString
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 DBString
Dim spare2 As DBString
Dim spare3 As DBString
Dim spare4 As DBString
Dim lastEditComment As DBString
Dim lastEditAt As Nullable(Of Date)
 
CertType.UpdateSpecific(sessionId, certName, maxLevel, audit, duration, hoursToRenew, availToOperations, availToOperationSteps, availToProducingItems, availToConsumingItems, availToAttributes, availToGradeChange, availToStateChange, availToLogData, totalSignOffsRequired, requireSignOffComments, signoffNotes, uptoExperimental, uptoApproved, uptoCertified, downToDisabled, downToExperimental, downToApproved, spare1, spare2, spare3, spare4, lastEditComment, lastEditAt)

public static void UpdateSpecific( 
   int sessionId,
   string certName,
   Nullable<int> maxLevel,
   Nullable<bool> audit,
   Nullable<int> duration,
   Nullable<int> hoursToRenew,
   Nullable<bool> availToOperations,
   Nullable<bool> availToOperationSteps,
   Nullable<bool> availToProducingItems,
   Nullable<bool> availToConsumingItems,
   Nullable<bool> availToAttributes,
   Nullable<bool> availToGradeChange,
   Nullable<bool> availToStateChange,
   Nullable<bool> availToLogData,
   DBInt totalSignOffsRequired,
   Nullable<bool> requireSignOffComments,
   DBString signoffNotes,
   Nullable<bool> uptoExperimental,
   Nullable<bool> uptoApproved,
   Nullable<bool> uptoCertified,
   Nullable<bool> downToDisabled,
   Nullable<bool> downToExperimental,
   Nullable<bool> downToApproved,
   DBString spare1,
   DBString spare2,
   DBString spare3,
   DBString spare4,
   DBString lastEditComment,
   ref Nullable<DateTime> lastEditAt
)

Parameters

sessionId

Required. Holds the session ID and thus the user who is making this method call.

certName

Required. Holds the name of the certification.

maxLevel

Optional. Holds the maximum level of the certification.

audit

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

duration

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

hoursToRenew

Optional. Holds the number of hours of work required to retain the certification.

availToOperations

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

availToOperationSteps

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

availToProducingItems

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

availToConsumingItems

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

availToAttributes

Optional. 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. 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. Holds a flag that indicates whether the certification can be applied to state changes.

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

availToLogData

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

totalSignOffsRequired

Optional. Holds the total number of sign-offs required.

requireSignOffComments

Optional. Holds a value indicating whether sign-off comments are required.

signoffNotes

Optional. Holds sign-off notes to show the user when signing off on this certification.

uptoExperimental

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