GetAll Method (DataEntrySched)
- Last UpdatedMar 17, 2026
- 4 minute read
The GetAll() method retrieves zero or more data entry shedule records from the Data_Entry_Sched table, as specified by the filter parameters. Passing no filter parameters will retrieve all data entry shedule records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal keyId As Nullable(Of Integer), _
ByVal keyType As Nullable(Of Integer), _
ByVal category As String, _
ByVal valueName As String, _
ByVal triggerType As Nullable(Of Integer), _
ByVal triggerPeriod As Nullable(Of Integer), _
ByVal entriesRequired As Nullable(Of Integer), _
ByVal lastTriggeredAt As Nullable(Of Date), _
ByVal lastTriggerDesc As String, _
ByVal stringSpare1 As String, _
ByVal stringSpare2 As String, _
ByVal stringSpare3 As String, _
ByVal stringSpare4 As String, _
ByVal numberSpare1 As Nullable(Of Double), _
ByVal numberSpare2 As Nullable(Of Double), _
ByVal numberSpare3 As Nullable(Of Double), _
ByVal numberSpare4 As Nullable(Of Double), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim keyId As Nullable(Of Integer)
Dim keyType As Nullable(Of Integer)
Dim category As String
Dim valueName As String
Dim triggerType As Nullable(Of Integer)
Dim triggerPeriod As Nullable(Of Integer)
Dim entriesRequired As Nullable(Of Integer)
Dim lastTriggeredAt As Nullable(Of Date)
Dim lastTriggerDesc As String
Dim stringSpare1 As String
Dim stringSpare2 As String
Dim stringSpare3 As String
Dim stringSpare4 As String
Dim numberSpare1 As Nullable(Of Double)
Dim numberSpare2 As Nullable(Of Double)
Dim numberSpare3 As Nullable(Of Double)
Dim numberSpare4 As Nullable(Of Double)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = DataEntrySched.GetAll(keyId, keyType, category, valueName, triggerType, triggerPeriod, entriesRequired, lastTriggeredAt, lastTriggerDesc, stringSpare1, stringSpare2, stringSpare3, stringSpare4, numberSpare1, numberSpare2, numberSpare3, numberSpare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> keyId,
Nullable<int> keyType,
string category,
string valueName,
Nullable<int> triggerType,
Nullable<int> triggerPeriod,
Nullable<int> entriesRequired,
Nullable<DateTime> lastTriggeredAt,
string lastTriggerDesc,
string stringSpare1,
string stringSpare2,
string stringSpare3,
string stringSpare4,
Nullable<double> numberSpare1,
Nullable<double> numberSpare2,
Nullable<double> numberSpare3,
Nullable<double> numberSpare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- keyId
- Optional filter parameter. Holds the primary key or row_id value of a row for which data is being collected.
- keyType
- Optional filter parameter. Holds a number that represents the type of data collection being done.
- category
- Optional filter parameter. Holds the category of the data collection.
- valueName
- Optional filter parameter. Holds the specific data or set of values to be collected within this category.
- triggerType
- Optional filter parameter. Holds a number that represents the trigger mechanism for the data collection.
- triggerPeriod
- Optional filter parameter. Holds the number of minutes between collection triggers if the trigger type is minutes.
- entriesRequired
- Optional filter parameter. Holds the number of entries required each time data collection is triggered.
- lastTriggeredAt
- Optional filter parameter. Holds the date/time if the last time the date entry schedule was triggered.
- lastTriggerDesc
- Optional filter parameter. Holds the description of the last trigger.
- stringSpare1
- Optional filter parameter. Holds the contents of a user-defined spare1 field.
- stringSpare2
- Optional filter parameter. Holds the contents of a user-defined spare2 field.
- stringSpare3
- Optional filter parameter. Holds the contents of a user-defined spare3 field.
- stringSpare4
- Optional filter parameter. Holds the contents of a user-defined spare4 field.
- numberSpare1
- Optional filter parameter. Holds the contents of a user-defined numeric spare1 field.
- numberSpare2
- Optional filter parameter. Holds the contents of a user-defined numeric spare2 field.
- numberSpare3
- Optional filter parameter. Holds the contents of a user-defined numeric spare3 field.
- numberSpare4
- Optional filter parameter. Holds the contents of a user-defined numeric spare4 field.
- lastEditBy
- Optional filter parameter. Holds the user who added or last changed a record.
- lastEditAt
- Optional filter parameter. Holds the date/time when a record was added or last edited.
Return Value
Returns a DataSet that contains records for all the data entry shedules that satisfy the specified filters. The returned records include columns from the Data_Entry_Sched table. If no matching certification/item links are found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
|
ColumnName |
Description |
|---|---|
|
key_id |
An integer that is the primary key or row ID on which the data collection schedule is based. |
|
key_type |
An integer that is an enumeration of the basis for this data collection (0=entity, 1=user group, 2=standard operation, 3=standard operation step, 4=operation, 5=operation step, 6=job, and 7=job step). |
|
category |
An string that is the category of the data entry schedule. |
|
value_name |
An string that is the name of the value being collected. |
|
trigger_type |
An integer that is the name of the value being collected (0=shift start, 1=shift end, 3=daily, 4=weekly, 5=minutes). |
|
trigger_period |
An integer that is the amount of time between data collections when the trigger type is minutes. |
|
entries_reqd |
An integer that is the number of entries required each time data collection is triggered. |
|
display_seq |
An integer that is the optional display sequence of the data entry schedule. |
|
last_trigger_at |
An date/time that is the last time the data entry schedule was triggered. |
|
last_trigger_desc |
An string that the description of the last trigger. |
|
string_spare1 |
A string that is the contents of the user-defined spare1 field. |
|
string_spare2 |
A string that is the contents of the user-defined spare2 field. |
|
string_spare3 |
A string that is the contents of the user-defined spare3 field. |
|
string_spare4 |
A string that is the contents of the user-defined spare4 field. |
|
number_spare1 |
A double that is the contents of the user-defined numeric spare1 field. |
|
number_spare2 |
A double that is the contents of the user-defined numberic spare2 field. |
|
number_spare3 |
A double that is the contents of the user-defined numeric spare3 field. |
|
number_spare4 |
A double that is the contents of the user-defined numeric spare4 field. |
|
last_edit_comment |
A string that contains comments about why the record was changed. |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. |
|
last_edit_at |
A datetime that indicates when the record was added or last updated. |