MES Stateless API

GetAll Method (GrpLineLink)

Save PDF

GetAll Method (GrpLineLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal grpId As Nullable(Of Integer), _
   ByVal lineId 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 lineId 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 = GrpLineLink.GetAll(grpId, lineId, access, lastEditBy, lastEditAt)

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

Parameters

grpId: Optional filter parameter. Holds the ID of a user group.
lineId: Optional filter parameter. Holds the ID of a line.
access: Optional filter parameter. Holds a flag that specifies whether the members of a user group may access this line.
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/line link record was added or last updated.

Return Value

Returns a DataSet that contains records for all the group/line link records that satisfy the specified filters. The returned records include columns from the Group_Name, Line, and Grp_Line_Link tables. If no matching group/line 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.
line_id	An integer that is the ID of the line.
grp_desc	A string that is the description of the user group from the Grp_Name table.
line_name	A string that is the name of the line from the Line table.
access	A Boolean that is a flag that specifies whether the members of the user group may access the line.
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