GetAll Method (DataLogValue)
- Last UpdatedNov 06, 2025
- 4 minute read
The GetAll() method retrieves one or more data log value records to the Data_Log_Value table, as specified by the filter parameters. Passing no filter parameters will retrieve all data log value records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal grpId As Nullable(Of Integer), _
ByVal valueIndex As Nullable(Of Integer), _
ByVal valueName As String, _
ByVal valueType As Nullable(Of Integer), _
ByVal editable As Nullable(Of Boolean), _
ByVal curValue As String, _
ByVal specId As String, _
ByVal meaning As Nullable(Of Integer), _
ByVal meaningToValueIndex As Nullable(Of Integer), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal modId As String _
) As DataSet
'Usage
Dim grpId As Nullable(Of Integer)
Dim valueIndex As Nullable(Of Integer)
Dim valueName As String
Dim valueType As Nullable(Of Integer)
Dim editable As Nullable(Of Boolean)
Dim curValue As String
Dim specId As String
Dim meaning As Nullable(Of Integer)
Dim meaningToValueIndex As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim modId As String
Dim value As DataSet
value = DataLogValue.GetAll(grpId, valueIndex, valueName, valueType, editable, curValue, specId, meaning, meaningToValueIndex, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt, modId)
public static DataSet GetAll(
Nullable<int> grpId,
Nullable<int> valueIndex,
string valueName,
Nullable<int> valueType,
Nullable<bool> editable,
string curValue,
string specId,
Nullable<int> meaning,
Nullable<int> meaningToValueIndex,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt,
string modId
)
Parameters
- grpId
- Optional filter parameter. Holds the ID of a data log group.
- valueIndex
- Optional filter parameter. Holds a value index.
- valueName
- Optional filter parameter. Holds a value's column name.
- valueType
- Optional filter parameter. Holds the enumeration of a value type.
- editable
- Optional filter parameter. Holds a flag that specifies whether the user can manually enter or modify the value.
- curValue
- Optional filter parameter. Holds a current value.
- specId
- Optional filter parameter. Holds a spec ID for the current running job.
- meaning
- This parameter is not used by the system.
- meaningToValueIndex
- This parameter is not used by the system.
- spare1
- Optional filter parameter. Holds the contents of the user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of the user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of the user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of the user-defined spare4 field.
- 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.
- modId
- Optional filter parameter. Holds a record modification ID by which to filter the records to be retrieved.
Return Value
Returns a DataSet that contains all the records in the Data_Log_Value 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 |
|---|---|
| grp_id | An integer that is the ID of the data log group. |
| value_index | An integer that is the value index. |
| value_name | A string that is the column name for that value. |
| value_type | An integer that is the data type of the value even though it is stored as a string. |
| editable | A Boolean that is a flag that indicates whether the user can manually enter or modify the value. |
| cur_value | A string that is the current value for the value. |
| spec_id | A string that is the spec ID from which the data log’s runtime value is sourced for the currently running job. |
| meaning | This parameter is not used by the system. |
| meaning_to_value_index | This parameter is not used by the system. |
| spare1 | A string that contains the spare1 field contents. |
| spare2 | A string that contains the spare2 field contents. |
| spare3 | A string that contains the spare3 field contents. |
| spare4 | A string that contains the spare4 field contents. |
| 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 date/time that indicates when the record was added or last modified. |
| mod_id | The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes. |