GetByKey Method (DataLog48)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetByKey() method retrieves the specified data log record from the Data_Log table.
Note: The methods in the DataLog48 class should not be used. They have been replaced by the DataLog class methods.
Parameters
- rowId
- Required. Holds the unique row ID of the data log record that is being retrieved.
Return Value
Returns a DataSet that contains the DataRow of the specified data log record in the Data_Log table that satisfy the specified filters. If no matching record is found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
| Column Names | Description |
|---|---|
| grp_id | An integer that is the ID of the DataLogGroup, from the Data_Log table. |
| sample_time | A datetime that indicates when the sample was taken based on the passed-in time zone bias. |
| sample_time_utc | A datetime that indicates when the sample was taken, in UTC, from the Data_Log table. |
| sample_time_local | A datetime that indicates when the sample was taken, in local time, from the Data_Log table. |
| wo_id | A string that is the ID of the work order, from the Data_Log table. |
| wo_desc | A string that is the description of the work order, from the WO table. |
| oper_id | A string that is the operation ID, from the Data_Log table. |
| seq_no | A string that is the sequence number of the operation and identifies the row in the Job table, from the Data_Log table. |
| job_desc | A string that is the description of the job, from the Job table. |
| step_no | A string that is the step number and identifies the step within the job, from the Data_Log table. |
| step_desc | A string that is the step description, from the Job_Step table. |
| item_id | A string that is the ID of the item to which the data applies, from the Data_Log table. |
| item_desc | A string that is the item's description, from the Item table. |
| lot_no | A string that is the lot number of the item to which the data applies, from the Data_Log table. |
| sublot_no | A string that is the sublot number of the item to which the data applies, from the Data_Log table. |
| shift_start | A datetime that indicates when the shift started based on the passed in time zone bias. |
| shift_start_utc | A datetime that indicates when the shift started, in UTC, from the Data_Log table. |
| shift_start_local | A datetime that indicates when the shift started, in local time, from the Data_Log table. |
| shift_id | An integer that identifies the shift ID, from the Data_Log table. |
| ent_id | An integer that identifies the entity from which the data came, from the Data_Log table. |
| genealogy_id | A string that identifies the PEM intra-segment genealogy ID, from the Data_Log table. |
| segment_requirement_id | A string that identifies the S95 segment requirement ID, from the Data_Log table. |
| segment_response_id | A string that identifies the S95 segment response ID, from the Data_Log table. |
| value1 to value48 | Strings that hold the values logged, from the Data_Log table. |
| last_edit_comment | A string that contains comments about why the record was added or updated, from the Data_Log table. |
| last_edit_by | A string that is the ID of the user who added or last updated this record, from the Data_Log table. |
| last_edit_at | A datetime that indicates when the record was added or last updated, from the Data_Log table. |
| row_id | An integer that is the unique row identifier for the record. |
Observe the following input parameter rules:
- Required non-DB* parameters: Must pass a value. Cannot be empty or null.
- Optional non-DB* parameters: Either enter a value or pass a null. If passing a null and a default value has been defined, the default value will be used for the parameter.
- Required DB* parameters: Must pass a value. To enter an empty value for the parameter, pass DB*.null (e.g., DBInt.null).
- Optional DB* parameters: To enter no value for the parameter, pass DB*.null (e.g., DBInt.null). To use the default value for the parameter if one has been defined for the object being added, pass a null.