GetByKey Method (DataLog)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetByKey() method retrieves the specified data log record from the Data_Log table.
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 values come from the Data_Log table unless otherwise noted.
| Column Names | Description |
|---|---|
| grp_id | An integer that is the ID of the data log group. |
| ent_id | An integer that is the ID of the entity from which the data came. |
| sample_time_utc | A datetime that indicates when the sample was first taken, in UTC. |
| sample_time_local | A datetime that indicates when the sample was first taken, in the entity's local time. |
| sample_time | A datetime that indicates when the sample was first taken, in the local time of the client application that is making the call. |
| wo_id | A string that is the ID of the work order. |
| oper_id | A string that is the operation ID. |
| seq_no | A string that is the operation sequence number of the job. |
| step_no | A string that is the step number and identifies the step within the job. |
| item_id | A string that is the ID of the item to which the data applies. |
| lot_no | A string that is the lot number of the item to which the data applies. |
| sublot_no | A string that is the sublot number of the item to which the data applies. |
| shift_id | An integer that is the shift ID. |
| shift_start_utc | A datetime that indicates when the shift started, in UTC. |
| shift_start_local | A datetime that indicates when the shift started, in the entity's local time. |
| genealogy_id | A string that is the PEM intra-segment genealogy ID. |
| segment_requirement_id | A string that is the S95 segment requirement ID. |
| segment_response_id | A string that is the S95 segment response ID. |
| value1 to value64 | Strings that hold the values logged. |
| last_edit_comment | A string that contains comments about why the record was added or updated. |
| 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. |
| created_at_utc | A datetime that indicates when the data log was created, in UTC. |
| created_at_local | A datetime that indicates when the data log was created, in the entity's local time. |
| row_id | An long integer value 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.