GetDataLogAdditions Method
- Last UpdatedNov 06, 2025
- 2 minute read
The GetDataLogAdditions() method retrieves the data log records that were added to the Data_Log table since they were last retrieved.
Note: Only one of the input parameters needs to be provided. If both are provided, only the higher row ID value is used.
'Declaration
Public Shared Function GetDataLogAdditions( _
ByVal dataLog16RowId As Nullable(Of Integer), _
ByVal dataLog48RowId As Nullable(Of Integer) _
) As DataSet
'Usage
Dim dataLog16RowId As Nullable(Of Integer)
Dim dataLog48RowId As Nullable(Of Integer)
Dim value As DataSet
value = DataLogGrp.GetDataLogAdditions(dataLog16RowId, dataLog48RowId)
public static DataSet GetDataLogAdditions(
Nullable<int> dataLog16RowId,
Nullable<int> dataLog48RowId
)
Parameters
- dataLog16RowId
- Optional. Holds the ID of the last retrieved row from the Data_Log table.
- dataLog48RowId
- Optional. Holds the ID of the last retrieved row from the Data_Log table.
Return Value
Returns a DataSet that contains records from the Data_Log table that that were added after the supplied row ID. If no matching records 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 ID of the entity that is linked to this Data_Log row. |
| job_pos | An integer that is the job position on which this job is running. |
| 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. |
| row_id | An integer that is the row ID of the record in the Data_Log table. |
| grp_id | An integer that is the unique ID of the data log group. |
| sample_time_utc | A datetime that is the shift start time when the sample was collected, in UTC. |
| sample_time_local | A datetime that is the shift start time when the sample was collected, in the entity's local time. |
| wo_id | A string that is the work order for which this sample was collected. |
| oper_id | A string that is the operation ID of the job for which this sample was collected. |
| seq_no | A string that is the operation sequence number of the job for which this sample was collected. |
| item_id | A string that is the ID of the item related to the job for which this sample was collected. |
| step_no | An integer that is the step number associated to this job for which this sample was collected. |
| lot_no | A string that is the number of the lot for which this sample was collected. |
| sublot_no | A string that is the number of the sublot for which this sample was collected. |
| dl_16_row_id | An integer that is the row ID of the record in the Data_Log table. |
| dl_48_row_id | An integer that is the row ID of the record in the Data_Log table. |
For input parameters that are not to be included, pass a null.
The DataSet is additionally filtered by jobs that are currently running, and the Data_Log rows returned are those that are added after the supplied rowId value.
For data logs with sample values that have no entries, those value columns are returned as null.