MES Stateless API

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<DateTime>) Method

Save PDF

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<DateTime>) Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

The GetAll() method retrieves one or more sample_char_rule_link records from the Sample_Char_Rule_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all sample records from the table.

This overload of the GetAll() method includes the chart position as a filter parameter.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal sampleId As Nullable(Of Integer), _
   ByVal charId As Nullable(Of Integer), _
   ByVal ruleId As Nullable(Of Integer), _
   ByVal chartPos As Nullable(Of Integer), _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim sampleId As Nullable(Of Integer)
Dim charId As Nullable(Of Integer)
Dim ruleId As Nullable(Of Integer)
Dim chartPos As Nullable(Of Integer)
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = SampleCharRuleLink.GetAll(sampleId, charId, ruleId, chartPos, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> sampleId,
   Nullable<int> charId,
   Nullable<int> ruleId,
   Nullable<int> chartPos,
   Nullable<DateTime> lastEditAt
)

Parameters

sampleId: Optional filter parameter. Holds a sample ID.
charId: Optional filter parameter. Holds a character ID.
ruleId: Optional filter parameter. Holds a specification ID from which a sample was generated.
chartPos: Optional filter parameter. Holds a position of a chart that is violating the control rule:

0 = top chart

1 = bottom chart

2 = both charts
lastEditAt: Optional filter parameter. Holds the datetime that a record was added or last edited.

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.
sample_name	A string that is the name of the sample.
char_id	An integer that is the unique ID of the characteristic.
char_name	A string that is the name of the characteristic.
rule_id	An integer that identifies the SPC rule that was violated.
rule_desc	A string that describes 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
priority	An integer that specifies the priority of the control rule.
note	A string that is a note about this sample for this characteristic.
cause_id	An integer that is the ID of the cause for this characteristic of this sample.
last_edit_at	A datetime that specifies when the record was added or last updated.

MES Stateless API