GetAll Method (DataLogGrp)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAll() method retrieves one or more data log group records from the Data_Log_Grp table, as specified by the filter parameters. Passing no filter parameters will retrieve all data log group records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal grpId As Nullable(Of Integer), _
ByVal grpDesc As String, _
ByVal maxValue As Nullable(Of Integer), _
ByVal triggerType As Nullable(Of Integer), _
ByVal obsolete As Nullable(Of Boolean), _
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) _
) As DataSet
'Usage
Dim grpId As Nullable(Of Integer)
Dim grpDesc As String
Dim maxValue As Nullable(Of Integer)
Dim triggerType As Nullable(Of Integer)
Dim obsolete As Nullable(Of Boolean)
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 value As DataSet
value = DataLogGrp.GetAll(grpId, grpDesc, maxValue, triggerType, obsolete, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> grpId,
string grpDesc,
Nullable<int> maxValue,
Nullable<int> triggerType,
Nullable<bool> obsolete,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- grpId
- Optional filter parameter. Holds the ID of the data log group.
- grpDesc
- Optional filter parameter. Holds the description of a data log group.
- maxValue
- Optional filter parameter. Holds the maximum of number of sample values that can be collected for the data log group. Beginning withg MES 7.0, this parameter is not used by the system. For new Data_Log_Group records, it defaults to 64.
- triggerType
- Optional filter parameter. Holds an enumeration that specifies what triggers data collection. Currently, only the manual trigger type (0) is supported by the system.
- obsolete
- Optional filter parameter. Holds a flag that indicates whether a data log group is obsolete.
- spare1
- Optional filter parameter. Holds the contents of a user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of a user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of a user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of a user-defined 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 all the records in the Data_Log_Grp 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 unique ID of the data log group. |
| grp_desc | A string that is the description of the data log group. |
| max_value | An integer that is the maximum of number of sample values that can be collected for the data log group. Beginning with MES 7.0, this field is not used by the system. For new Data_Log_Group records, it defaults to 64. |
| trigger_type | An integer that is the enumeration of the trigger type that triggers data collection. Currently, only the manual trigger type (0) is supported by the system. |
| trigger_detail | A string that is the XML-encoded detail for the trigger, which depends on the trigger type. Because this parameter does not apply to the manual trigger type, it is not currently used by the system. |
| obsolete | A Boolean that is a flag that indicates whether this data log group is obsolete or not. |
| spare1 | A string that is the contents of the user-defined spare1 field. |
| spare2 | A string that is the contents of the user-defined spare2 field. |
| spare3 | A string that is the contents of the user-defined spare3 field. |
| spare4 | A string that is the contents of the user-defined 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. |
| 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. |