GetAll Method (Shift)
- Last UpdatedNov 06, 2025
- 2 minute read
The GetAll() method retrieves one or more shift records from the Shift table, as specified by the filter parameters. Passing no filter parameters will retrieve all shift records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal shiftId As Nullable(Of Integer), _
ByVal shiftDesc As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim shiftId As Nullable(Of Integer)
Dim shiftDesc As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Shift.GetAll(shiftId, shiftDesc, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> shiftId,
string shiftDesc,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- shiftId
- Optional filter parameter. Holds the ID of a shift.
- shiftDesc
- Optional filter parameter. Holds the description for a shift.
- lastEditBy
- Optional filter parameter. Holds the ID of the user who added or last updated a shift record.
- lastEditAt
- Optional filter parameter. Holds the date/time when a shift record was added or last updated.
Return Value
Returns a DataSet that contains all the records in the Shift 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 |
|---|---|
|
Shiftid |
An integer that is the shift ID. |
|
Shiftdesc |
A string that is the shift description. |
|
LastEditComment |
A string that contains comments about why the record was added or updated. |
|
LastEditBy |
A string that is the ID of the user who added or last updated this record. |
|
LastEditAt |
A date/time that indicates when the record was added or last updated. |