MES Stateless API

GetAll Method (CertItemLink)

Save PDF

GetAll Method (CertItemLink)

Save PDF

Last UpdatedMar 17, 2026
2 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal certName As String, _
   ByVal itemId 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 itemId As String
Dim certLevel As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = CertItemLink.GetAll(certName, itemId, certLevel, lastEditBy, lastEditAt)

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

Parameters

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

Return Value

Returns a DataSet that contains records for all the certification/item links that satisfy the specified filters. The returned records include columns from the Cert_Item_Link, Cert_Type, and Item tables. If no matching certification/item 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 item.
item_id	A string that is the ID of the item linked to the certification.
cert_level	An integer that is the certification level required to access the item.
item_desc	An string that is the description of the item, from the Item table.
max_level	An integer that is the maximum value that can be entered in the cert_level field, from the Cert_Type 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