MES Stateless API

GetAll Method (ShiftSched)

Save PDF

GetAll Method (ShiftSched)

Save PDF

Last UpdatedNov 06, 2025
4 minute read

The GetAll() method retrieves one or more shift schedule records from the Shift_Sched table, as specified by the filter parameters. Passing no filter parameters will retrieve all shift schedule records from the table.

Note: This method is no longer supported. Instead, use the corresponding method in the ShiftSchedule class.

Syntax

'Declaration
 
<ObsoleteAttribute("ShiftSched.GetAll method is no longer supported. Please call the corresponding updated method.")>
Public Shared Function GetAll( _
   ByVal entId As Nullable(Of Integer), _
   ByVal startDay As Nullable(Of Integer), _
   ByVal shiftId As Nullable(Of Integer), _
   ByVal startTime As Nullable(Of Date), _
   ByVal endTime As Nullable(Of Date), _
   ByVal break1Start As Nullable(Of Date), _
   ByVal break1End As Nullable(Of Date), _
   ByVal break2Start As Nullable(Of Date), _
   ByVal break2End As Nullable(Of Date), _
   ByVal break3Start As Nullable(Of Date), _
   ByVal break3End As Nullable(Of Date), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim entId As Nullable(Of Integer)
Dim startDay As Nullable(Of Integer)
Dim shiftId As Nullable(Of Integer)
Dim startTime As Nullable(Of Date)
Dim endTime As Nullable(Of Date)
Dim break1Start As Nullable(Of Date)
Dim break1End As Nullable(Of Date)
Dim break2Start As Nullable(Of Date)
Dim break2End As Nullable(Of Date)
Dim break3Start As Nullable(Of Date)
Dim break3End As Nullable(Of Date)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = ShiftSched.GetAll(entId, startDay, shiftId, startTime, endTime, break1Start, break1End, break2Start, break2End, break3Start, break3End, lastEditBy, lastEditAt)

[Obsolete("ShiftSched.GetAll method is no longer supported. Please call the corresponding updated method.")]
public static DataSet GetAll( 
   Nullable<int> entId,
   Nullable<int> startDay,
   Nullable<int> shiftId,
   Nullable<DateTime> startTime,
   Nullable<DateTime> endTime,
   Nullable<DateTime> break1Start,
   Nullable<DateTime> break1End,
   Nullable<DateTime> break2Start,
   Nullable<DateTime> break2End,
   Nullable<DateTime> break3Start,
   Nullable<DateTime> break3End,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

entId: Optional filter parameter. Holds the ID of the entity to which the shift schedule applies.
startDay: Optional filter parameter. Holds an integer that indicates the shift's start day of the week. The value 0 = Sunday and 6 = Saturday.
shiftId: Optional filter parameter. Holds the ID of the shift to which the schedule applies.
startTime: Optional filter parameter. Holds a shift start time (the date is ignored).
endTime: Optional filter parameter. Holds a shift end time (the date is ignored).
break1Start: Optional filter parameter. Holds a shift break1 start time (the date is ignored).
break1End: Optional filter parameter. Holds a shift break1 end time (the date is ignored).
break2Start: Optional filter parameter. Holds a shift break2 start time (the date is ignored).
break2End: Optional filter parameter. Holds a shift break2 end time (the date is ignored).
break3Start: Optional filter parameter. Holds a shift break3 start time (the date is ignored).
break3End: Optional filter parameter. Holds a shift break3 end time (the date is ignored).
lastEditBy: Optional filter parameter. Holds the name of the user who added or last changed a shift schedule record.
lastEditAt: Optional filter parameter. Holds the date/time when a shift schedule record was added or last changed.

Return Value

Returns a DataSet that contains records for all the shift schedules that satisfy the specified filters. The returned records include columns from the Shift_Sched, Shift, and Ent tables. If no matching shift schedules are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
ent_id	An integer that is the entity ID, from the Shift_Sched table
start_day	An integer that indicates the start day, from the Shift_Sched table
shift_id	An integer that is the shift ID, from the Shift_Sched table
start_time	A date/time that is the shift start time, from the Shift_Sched table
shift_desc	A string that is the description of the shift, from the Shift table.
ent_name	A string that is the entity name, from the Ent table
end_time	A date/time that is the shift end time, from the Shift_Sched table
break1_start	A date/time that is the break1 start time, from the Shift_Sched table
break1_end	A date/time that is the break1 end time, from the Shift_Sched table
break2_start	A date/time that is the break2 start time, from the Shift_Sched table
break2_end	A date/time that is the break2 end time, from the Shift_Sched table
break3_start	A date/time that is the break3 start time, from the Shift_Sched table
break3_end	A date/time that is the break3 end time, from the Shift_Sched table
last_edit_comment	A string that contains comments about why the record was changed, from the Shift_Sched table.
last_edit_by	A string that is the ID of the user who added or last updated this record, from the Shift_Sched table.
last_edit_at	A date/time that indicates when the record was added or last updated, from the Shift_Sched table.

MES Stateless API