MES Stateless API

GetAll Method (ShiftPatternEntLink)

Save PDF

GetAll Method (ShiftPatternEntLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAll() method retrieves one or more shift pattern-entity link records from the Shift_Pattern_Ent_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all shift pattern-entity link records from the table.

Syntax

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

'Usage
 
Dim shiftSchedEntId As Nullable(Of Integer)
Dim entId As Nullable(Of Integer)
Dim patternId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = ShiftPatternEntLink.GetAll(shiftSchedEntId, entId, patternId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> shiftSchedEntId,
   Nullable<int> entId,
   Nullable<int> patternId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

shiftSchedEntId: Optional filter parameter. Holds the ID of an entity that supplies the shift schedule for an entity that is linked to a shift pattern.
entId: Optional filter parameter. Holds the ID of an entity that is linked to a shift pattern.
patternId: Optional filter parameter. Holds the ID of a shift pattern that is linked to an entity.
lastEditBy: Optional filter parameter. Holds the user who added or last changed this record and by which to filter the records to be retrieved.
lastEditAt: Optional filter parameter. Holds the datetime when a record was added or last edited and by which to filter the records to be retrieved.

Return Value

Returns a DataSet that contains all the records in the Shift_Pattern_Ent_Link table that satisfy the specified filters. If no matching records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
shift_sched_ent_id	An integer that is the ID of the entity that supplies the shift schedule for the entity that is linked to the shift pattern (ent_id).
shift_sched_ent_name	A string that is the name of the entity that supplies the shift schedule for the entity that is linked to the shift pattern (ent_id). From the Ent table.
shift_sched_ent_tz_id	A string that is the time zone ID of the entity that supplies the shift schedule for the entity that is linked to the shift pattern (ent_id). Via links to the Ent, then Site tables.
ent_id	An integer that is the ID of the entity that is linked to the shift pattern.
ent_name	A string that is the name of the entity that is linked to the shift pattern. From the Ent table.
ent_tz_id	A string that is the time zone ID of the entity that is linked to the shift pattern. Via links to the Ent, then Site tables.
pattern_id	An integer that is the ID of the shift pattern.
last_edit_comment	A string that contains any comments about why the record was changed.
last_edit_by	A string that is the ID of the user who added or last modified this record.
last_edit_at	A datetime that indicates when the record was added or last modified.

MES Stateless API