MES Stateless API

GetAll Method (CertUserLink)

Save PDF

GetAll Method (CertUserLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

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

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

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

Parameters

certName: Optional filter parameter. Holds the name of a certification.
userId: Optional filter parameter. Holds the ID of a user.
certLevel: Optional filter parameter. Holds a certification level.
expiryTime: Optional filter parameter. Holds a date when the certification is going to expire for the linked user.
lastEditBy: Optional filter parameter. Holds the name of a user who last changed a certification user link record.
lastEditAt: Optional filter parameter. Holds a date/time when a certification user link record was added or last changed.

Return Value

Returns a DataSet that contains records for all the certification user links that satisfy the specified filters. The returned records include columns from the Cert_User_Link and User_Name tables. If no matching certification/user 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 user.
user_id	A string that is the ID of the user linked to the certification.
cert_level	An integer that is the certification level required .
expiry	A date/time that indicates when the certification is going to expire for the linked user.
user_desc	A string that is the description of the user, from the User_Name 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/time that indicates when the record was added or last updated.

MES Stateless API