MES Stateless API

GetByKey Method (SampleCharRuleLink)

Save PDF

GetByKey Method (SampleCharRuleLink)

Save PDF

Last UpdatedMar 17, 2026
1 minute read

The GetByKey() method retrieves the specified sample_char_rule_link record from the Sample_Char_Rule_Link table.

Syntax

'Declaration
 
Public Shared Function GetByKey( _
   ByVal sampleId As Integer, _
   ByVal charId As Integer, _
   ByVal ruleId As Integer _
) As DataSet

'Usage
 
Dim sampleId As Integer
Dim charId As Integer
Dim ruleId As Integer
Dim value As DataSet
 
value = SampleCharRuleLink.GetByKey(sampleId, charId, ruleId)

public static DataSet GetByKey( 
   int sampleId,
   int charId,
   int ruleId
)

Parameters

sampleId: Required. Holds the sample ID of the record being retrieved.
charId: Required. Holds the characteristic ID of the record being retrieved.
ruleId: Required. Holds the rule ID of the record being retrieved.

Return Value

Returns a DataSet that contains records from the Sample_Char_Rule_Link 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
sample_id	An integer that is the unique ID of the sample.
char_id	An integer that is the unique ID of the characteristic.
rule_id	An integer that identifies the SPC rule that was violated.
chart_pos	An integer that identifies the position of the chart that is violating the control rule: 0 = top chart 1 = bottom chart 2 = both charts
last_edit_at	A datetime that specifies when the record was added or last updated.

MES Stateless API

GetByKey Method (SampleCharRuleLink)

Table of Contents

GetByKey Method (SampleCharRuleLink)

In This Topic

MES Stateless API

GetByKey Method (SampleCharRuleLink)

Syntax

Parameters

Return Value

See Also

Reference

In This Topic