Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

MES Stateless API

TABLE OF CONTENTS

GetByKey Method (DataLog16)

Save PDF
Save selected topicSave selected topic and subtopicsSave all topics
Share
Share to emailCopy topic URL

The GetByKey() method retrieves the specified data log record from the Data_Log table.

Note: The methods in the DataLog16 class should not be used. They have been replaced by the DataLog class methods.

Syntax

'Declaration
 
Public Shared Function GetByKey( _
   ByVal rowId As Integer _
) As DataSet
'Usage
 
Dim rowId As Integer
Dim value As DataSet
 
value = DataLog16.GetByKey(rowId)
public static DataSet GetByKey( 
   int rowId
)

Parameters

rowId
Required. Holds the unique rowId 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_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.
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.
step_no A string that is the step number and identifies the step within the job, from the Data_Log table.
item_id A string that is the ID of the item to which the data applies, from the Data_Log 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_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 value16 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.

See Also

Reference

DataLog16 Class
DataLog16 Members

In This Topic
TitleResults for “How to create a CRG?”Also Available in