MES Stateless API

GetAll Method (GrpEntLink)

Save PDF

GetAll Method (GrpEntLink)

Save PDF

Last UpdatedMar 17, 2026
2 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal grpId As Nullable(Of Integer), _
   ByVal entId As Nullable(Of Integer), _
   ByVal access As Nullable(Of Boolean), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim grpId As Nullable(Of Integer)
Dim entId As Nullable(Of Integer)
Dim access As Nullable(Of Boolean)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = GrpEntLink.GetAll(grpId, entId, access, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> grpId,
   Nullable<int> entId,
   Nullable<bool> access,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

grpId: Optional filter parameter. Holds the ID of a user group.
entId: Optional filter parameter. Holds the ID of an entity.
access: Optional filter parameter. Holds a flag that specifies whether the members of a user group may log onto this entity.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated a group/entity link record.
lastEditAt: Optional filter parameter. Holds the date/time when a group/entity link record was added or last updated.

Return Value

Returns a DataSet that contains records for all the group/entity link records that satisfy the specified filters. The returned records include columns from the Group_Name, Ent and Grp_Ent_Link tables. If no matching group/entity link records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

ColumnName	Description
grp_id	An integer that is the ID of the user group.
ent_id	An integer that is the ID of the entity.
grp_desc	A string that is the description of the user group from the Grp_Name table.
ent_name	A string that is the description of the entity from the Ent table.
access	A Boolean that is a flag that specifies whether the members of the user group may log onto the entity.
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