GetAll Method (QmSpecRuleLink)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal qmSpecId As Nullable(Of Integer), _
ByVal ruleId As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim qmSpecId As Nullable(Of Integer)
Dim ruleId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = QmSpecRuleLink.GetAll(qmSpecId, ruleId, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> qmSpecId,
Nullable<int> ruleId,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- qmSpecId
- Required. Holds the ID assigned to the specification that is being linked.
- ruleId
- Required. Holds the rule ID to be linked to the specification ID.
- lastEditBy
- Optional. Holds the ID of a user who added the link record.
- lastEditAt
- Optional. Holds the datetime when a link record was added.
Return Value
Returns a DataSet that contains all the records in the Char_Attr_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 |
|---|---|
|
qm_spec_id |
An Integer which is unique to the qm specification. (from qm_spec_rule_link) |
|
rule_id |
An Integer which is unique to the rule. (from qm_spec_rule_link) |
|
rule_desc |
A string which is the description of the rule. (from spc_rule) |
|
use_for_ix |
A Boolean flag which indicates whether or not the rule is used for individual X charts. (from spc_rule) |
|
use_for_mr |
A Boolean flag which indicates whether or not the rule is used for moving range charts. (from spc_rule) |
|
use_for_xbar |
A Boolean flag which indicates whether or not the rule is used for x bar charts. (from spc_rule) |
|
use_for_range |
A Boolean flag which indicates whether or not the rule is used for range charts. (from spc_rule) |
|
use_for_sigma |
A Boolean flag which indicates whether or not the rule is used for sigma charts. (from spc_rule) |
|
use_for_ma |
A Boolean flag which indicates whether or not the rule is used for moving average charts. (from spc_rule) |
|
use_for_ewmaix |
A Boolean flag which indicates whether or not the rule is used for exponentially-weighted moving average charts (currently unused). (from spc_rule) |
|
use_for_run |
A Boolean flag which indicates whether or not the rule is used for run charts (currently unused). (from spc_rule) |
|
use_for_attr |
A Boolean flag which indicates whether or not the rule is used for attribute charts. (from spc_rule) |
|
test1 |
An integer enumeration for primary test, if any: 1=trend up,2=trend down,3=run above,4=run below,5=run within,6=run beyond,7=alternating about,8=capability sigma above,9-Cpk above, 10=mean above, 11=Ppk above, 12=standard deviation above. (from spc_rule) |
|
test2 |
An integer enumeration for secondary test, if any 1=trend up,2=trend down,3=run above,4=run below,5=run within,6=run beyond,7=alternating about,8=capability sigma below,9-Cpk below, 10=mean below, 11=Ppk below, 12=standard deviation below. (from spc_rule) |
|
and_not_or |
An Boolean flag which indicates how test1 and test2 affect an out-of-control condition: True if both conditions must be met for the process to be considered out-of-control; False if either is enough, or if either test1 or test2 is null. (from spc_rule) |
|
level1 |
An integer which indicates the value in standard deviations to apply to test1 if applicable. If test1=3,4,or 6, NULL = control limits. If test1=9 or 11, value is dimensionless. If test1=10, value is in units of the characteristic. (from spc_rule) |
|
level2 |
An integer which indicates the value in standard deviations to apply to test2 if applicable. If test2=3,4,or 6, NULL = control limits. If test2=9 or 11, value is dimensionless. If test2=10, value is in units of the characteristic. (from spc_rule) |
|
num_points |
An integer which is the number of subgroups that must meet the critieria in order for the condition to be satisfied. (from spc_rule) |
|
of_points |
An integer which is the number of subgroups to check at a time, from with num_points are gotten. (from spc_rule) |
|
priority |
An integer which is the relative importance of rule violations, lower numbers more important than higher. (from spc_rule) |
|
obsolete |
An boolean flag which indicates whether or not this rule is no longer used; True = obsolete, False = not obsolete. (from spc_rule) |
|
last_edit_comment |
A string that is the comment for the last edit of the row. (from qm_spec_rule_link) |
|
last_edit_by |
A string that is the ID of the user who added or last updated this record. (from qm_spec_rule_link) |
|
last_edit_at |
A date/time that indicates when the record was added or last updated. (from qm_spec_rule_link) |