GetAll Method (QmSpecCharLink)

Save PDF

Last UpdatedNov 06, 2025
16 minute read

The GetAll() method retrieves one or more specification-characteristic link records from the Qm_Spec_Char_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all specification-characteristic link records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal qmSpecId As Nullable(Of Integer), _
   ByVal qmSpecName As String, _
   ByVal charId As Nullable(Of Integer), _
   ByVal charName As String, _
   ByVal type As Nullable(Of Integer), _
   ByVal target As Nullable(Of Double), _
   ByVal lsv As Nullable(Of Double), _
   ByVal usv As Nullable(Of Double), _
   ByVal lsvIsOffset As Nullable(Of Boolean), _
   ByVal usvIsOffset As Nullable(Of Boolean), _
   ByVal lsvOffsetIsPct As Nullable(Of Boolean), _
   ByVal usvOffsetIsPct As Nullable(Of Boolean), _
   ByVal lrv As Nullable(Of Double), _
   ByVal urv As Nullable(Of Double), _
   ByVal lrvIsMult As Nullable(Of Boolean), _
   ByVal urvIsMult As Nullable(Of Boolean), _
   ByVal severityCd As Nullable(Of Integer), _
   ByVal planId As Nullable(Of Integer), _
   ByVal sampleSizeSource As Nullable(Of Integer), _
   ByVal normalSampleSize As Nullable(Of Integer), _
   ByVal minimumSampleSize As Nullable(Of Integer), _
   ByVal maximumSampleSize As Nullable(Of Integer), _
   ByVal clSource As Nullable(Of Integer), _
   ByVal samplesForCl As Nullable(Of Integer), _
   ByVal stdAvg As Nullable(Of Double), _
   ByVal stdAvgIsTarget As Nullable(Of Integer), _
   ByVal stdDeviation As Nullable(Of Double), _
   ByVal clXbar As Nullable(Of Double), _
   ByVal lclXbar As Nullable(Of Double), _
   ByVal uclXbar As Nullable(Of Double), _
   ByVal clRange As Nullable(Of Double), _
   ByVal lclRange As Nullable(Of Double), _
   ByVal uclRange As Nullable(Of Double), _
   ByVal clSigma As Nullable(Of Double), _
   ByVal lclSigma As Nullable(Of Double), _
   ByVal uclSigma As Nullable(Of Double), _
   ByVal clIx As Nullable(Of Double), _
   ByVal lclIx As Nullable(Of Double), _
   ByVal uclIx As Nullable(Of Double), _
   ByVal clImr As Nullable(Of Double), _
   ByVal lclImr As Nullable(Of Double), _
   ByVal uclImr As Nullable(Of Double), _
   ByVal clMa As Nullable(Of Double), _
   ByVal lclMa As Nullable(Of Double), _
   ByVal uclMa As Nullable(Of Double), _
   ByVal clMr As Nullable(Of Double), _
   ByVal lclMr As Nullable(Of Double), _
   ByVal uclMr As Nullable(Of Double), _
   ByVal clMs As Nullable(Of Double), _
   ByVal lclMs As Nullable(Of Double), _
   ByVal uclMs As Nullable(Of Double), _
   ByVal clP As Nullable(Of Double), _
   ByVal lclP As Nullable(Of Double), _
   ByVal uclP As Nullable(Of Double), _
   ByVal clNp As Nullable(Of Double), _
   ByVal lclNp As Nullable(Of Double), _
   ByVal uclNp As Nullable(Of Double), _
   ByVal clC As Nullable(Of Double), _
   ByVal lclC As Nullable(Of Double), _
   ByVal uclC As Nullable(Of Double), _
   ByVal clU As Nullable(Of Double), _
   ByVal lclU As Nullable(Of Double), _
   ByVal uclU As Nullable(Of Double), _
   ByVal defaultChart As Nullable(Of Integer), _
   ByVal automatedColl As Nullable(Of Integer), _
   ByVal timeInterval As Nullable(Of Integer), _
   ByVal timeIntUnit As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim qmSpecId As Nullable(Of Integer)
Dim qmSpecName As String
Dim charId As Nullable(Of Integer)
Dim charName As String
Dim type As Nullable(Of Integer)
Dim target As Nullable(Of Double)
Dim lsv As Nullable(Of Double)
Dim usv As Nullable(Of Double)
Dim lsvIsOffset As Nullable(Of Boolean)
Dim usvIsOffset As Nullable(Of Boolean)
Dim lsvOffsetIsPct As Nullable(Of Boolean)
Dim usvOffsetIsPct As Nullable(Of Boolean)
Dim lrv As Nullable(Of Double)
Dim urv As Nullable(Of Double)
Dim lrvIsMult As Nullable(Of Boolean)
Dim urvIsMult As Nullable(Of Boolean)
Dim severityCd As Nullable(Of Integer)
Dim planId As Nullable(Of Integer)
Dim sampleSizeSource As Nullable(Of Integer)
Dim normalSampleSize As Nullable(Of Integer)
Dim minimumSampleSize As Nullable(Of Integer)
Dim maximumSampleSize As Nullable(Of Integer)
Dim clSource As Nullable(Of Integer)
Dim samplesForCl As Nullable(Of Integer)
Dim stdAvg As Nullable(Of Double)
Dim stdAvgIsTarget As Nullable(Of Integer)
Dim stdDeviation As Nullable(Of Double)
Dim clXbar As Nullable(Of Double)
Dim lclXbar As Nullable(Of Double)
Dim uclXbar As Nullable(Of Double)
Dim clRange As Nullable(Of Double)
Dim lclRange As Nullable(Of Double)
Dim uclRange As Nullable(Of Double)
Dim clSigma As Nullable(Of Double)
Dim lclSigma As Nullable(Of Double)
Dim uclSigma As Nullable(Of Double)
Dim clIx As Nullable(Of Double)
Dim lclIx As Nullable(Of Double)
Dim uclIx As Nullable(Of Double)
Dim clImr As Nullable(Of Double)
Dim lclImr As Nullable(Of Double)
Dim uclImr As Nullable(Of Double)
Dim clMa As Nullable(Of Double)
Dim lclMa As Nullable(Of Double)
Dim uclMa As Nullable(Of Double)
Dim clMr As Nullable(Of Double)
Dim lclMr As Nullable(Of Double)
Dim uclMr As Nullable(Of Double)
Dim clMs As Nullable(Of Double)
Dim lclMs As Nullable(Of Double)
Dim uclMs As Nullable(Of Double)
Dim clP As Nullable(Of Double)
Dim lclP As Nullable(Of Double)
Dim uclP As Nullable(Of Double)
Dim clNp As Nullable(Of Double)
Dim lclNp As Nullable(Of Double)
Dim uclNp As Nullable(Of Double)
Dim clC As Nullable(Of Double)
Dim lclC As Nullable(Of Double)
Dim uclC As Nullable(Of Double)
Dim clU As Nullable(Of Double)
Dim lclU As Nullable(Of Double)
Dim uclU As Nullable(Of Double)
Dim defaultChart As Nullable(Of Integer)
Dim automatedColl As Nullable(Of Integer)
Dim timeInterval As Nullable(Of Integer)
Dim timeIntUnit As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = QmSpecCharLink.GetAll(qmSpecId, qmSpecName, charId, charName, type, target, lsv, usv, lsvIsOffset, usvIsOffset, lsvOffsetIsPct, usvOffsetIsPct, lrv, urv, lrvIsMult, urvIsMult, severityCd, planId, sampleSizeSource, normalSampleSize, minimumSampleSize, maximumSampleSize, clSource, samplesForCl, stdAvg, stdAvgIsTarget, stdDeviation, clXbar, lclXbar, uclXbar, clRange, lclRange, uclRange, clSigma, lclSigma, uclSigma, clIx, lclIx, uclIx, clImr, lclImr, uclImr, clMa, lclMa, uclMa, clMr, lclMr, uclMr, clMs, lclMs, uclMs, clP, lclP, uclP, clNp, lclNp, uclNp, clC, lclC, uclC, clU, lclU, uclU, defaultChart, automatedColl, timeInterval, timeIntUnit, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> qmSpecId,
   string qmSpecName,
   Nullable<int> charId,
   string charName,
   Nullable<int> type,
   Nullable<double> target,
   Nullable<double> lsv,
   Nullable<double> usv,
   Nullable<bool> lsvIsOffset,
   Nullable<bool> usvIsOffset,
   Nullable<bool> lsvOffsetIsPct,
   Nullable<bool> usvOffsetIsPct,
   Nullable<double> lrv,
   Nullable<double> urv,
   Nullable<bool> lrvIsMult,
   Nullable<bool> urvIsMult,
   Nullable<int> severityCd,
   Nullable<int> planId,
   Nullable<int> sampleSizeSource,
   Nullable<int> normalSampleSize,
   Nullable<int> minimumSampleSize,
   Nullable<int> maximumSampleSize,
   Nullable<int> clSource,
   Nullable<int> samplesForCl,
   Nullable<double> stdAvg,
   Nullable<int> stdAvgIsTarget,
   Nullable<double> stdDeviation,
   Nullable<double> clXbar,
   Nullable<double> lclXbar,
   Nullable<double> uclXbar,
   Nullable<double> clRange,
   Nullable<double> lclRange,
   Nullable<double> uclRange,
   Nullable<double> clSigma,
   Nullable<double> lclSigma,
   Nullable<double> uclSigma,
   Nullable<double> clIx,
   Nullable<double> lclIx,
   Nullable<double> uclIx,
   Nullable<double> clImr,
   Nullable<double> lclImr,
   Nullable<double> uclImr,
   Nullable<double> clMa,
   Nullable<double> lclMa,
   Nullable<double> uclMa,
   Nullable<double> clMr,
   Nullable<double> lclMr,
   Nullable<double> uclMr,
   Nullable<double> clMs,
   Nullable<double> lclMs,
   Nullable<double> uclMs,
   Nullable<double> clP,
   Nullable<double> lclP,
   Nullable<double> uclP,
   Nullable<double> clNp,
   Nullable<double> lclNp,
   Nullable<double> uclNp,
   Nullable<double> clC,
   Nullable<double> lclC,
   Nullable<double> uclC,
   Nullable<double> clU,
   Nullable<double> lclU,
   Nullable<double> uclU,
   Nullable<int> defaultChart,
   Nullable<int> automatedColl,
   Nullable<int> timeInterval,
   Nullable<int> timeIntUnit,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

qmSpecId

Optional. Holds the ID of the specification linked.

qmSpecName

Optional. Holds the name of the specification linked.

charId

Optional. Holds the ID of the characteristic linked.

charName

Optional. Holds the name of the characteristic linked.

type

Optional. Holds the type of the characteristic linked.

target

Required. Holds the target value for this characteristic.

lsv

Optional. Holds the lower specification value

usv

Optional. Holds the upper specification value

lsvIsOffset

Optional. Holds a logical data type (which is a flag) if lsv is the difference between target and lsl, that is, lsv is not equal to lower spec limit (lsl) but is an offset. Default = Yes.

usvIsOffset

Optional. Holds a logical data type (which is a flag) if usv is the difference between usl and target, that is, usv is not equal to upper spec limit (usl) but is an offset. Default = Yes.

lsvOffsetIsPct

Optional. Holds a logical data type (which is a flag) if lsv is an offset. Is it a percent of the target? Default = Yes.

usvOffsetIsPct

Optional. Holds a logical data type (which is a flag) if usv is an offset. Is it a percent of the target? Default = Yes.

lrv

Optional. Holds the lower reasonable value.

urv

Optional. Holds the upper reasonable value.

lrvIsMult

Optional. Holds a logical data type (which is a flag) if lrv is a multiplier for the difference between the lower spec limits and target, to find offset from target for lrl; if not, lrv - lower reasonable limit (an absolute value) Default = No

urvIsMult

Optional. Holds a logical data type (which is a flag) if urv is a multiplier for the difference between the upper spec limits and target, to find offset from target for url; if no, urv = upper reasonable limit (an absolute value) Default = No

severityCd

Optional. Holds the severity of the characteristic. 0 = Unused (not available for data entry), 1 = Not Monitored (run rule violations not checked), 2 = Non-Key (Default), 3 = Key, 4 = Critical

planId

Unused. Holds the ID of the plan. This will not be considered as a filter parameter.

sampleSizeSource

Optional. Holds the source of the sample size. If type = 1 (attribute) 0 = fixed (default), 1 = entered, 2 = entered but copied from the previous value.

normalSampleSize

Optional. Holds the normal number of measurements in a sample. If variable or attribute with fixed sample size, the normal number of measurements in a sample. If variable and normal_sample_size = 1, then data is not grouped.

minimumSampleSize

Optional. Holds the minimum number of measurements in a sample. Default = 1.

maximumSampleSize

Optional. Holds the maximum number of measurements in a sample.

clSource

Optional. Holds an enumeration that indicates the control limit source.

0 = automatically calculate from data (default)

1 = compute from standard mean and standard deviation values (if variable) or compute from standard p, np average proportion and standard c, u average number per unit values (if attribute)

2 = use preset values

samplesForCl

Optional. Holds the number of samples to use for the calculation of control limits. If cl_source = 0, the number of samples to use for the calculation of control limits. 0 (default) = use all.

stdAvg

Optional. Holds the standard average value.

If cl_source = 1 and type is variable, this is the standard mean.

If type is binary attribute, this is the standard p, np average proportion value.

If type is counted attribute this is the standard c, u average number per unit value.

stdAvgIsTarget

Optional. Holds the value 1 to use the target instead of the std_avg value as the standard, else 0. If not null, used to override the std_avg_is_target setting for the characteristic.

stdDeviation

Optional. Holds the standard deviation value. If variable and cl_source = 1, the standard deviation value.

clXbar

Optional. Holds the center line for xbar chart. If variable and cl_source = 2, center line for xbar.

lclXbar

Optional. Holds the lower control limit for xbar chart. If variable and cl_source = 2, lower control limit for xbar.

uclXbar

Optional. Holds the upper control limit for xbar chart. If variable and cl_source = 2, upper control limit for xbar.

clRange

Optional. Holds the center line for range. If variable and cl_source = 2, center line for range.

lclRange

Optional. Holds the lower control limit for range. If variable and cl_source = 2, lower control limit for range.

uclRange

Optional. Holds the upper control limit for range. If variable and cl_source = 2, upper control limit for range.

clSigma

Optional. Holds the center line for sigma. If variable and cl_source = 2, center line for sigma.

lclSigma

Optional. Holds the lower control limit for sigma. If variable and cl_source = 2, lower control limit for sigma.

uclSigma

Optional. Holds the upper control limit for sigma. If variable and cl_source = 2, upper control limit for sigma.

clIx

Optional. Holds the center line for individual x. If variable and cl_source = 2, center line for an individual x.

lclIx

Optional. Holds the lower control limit for individual x. If variable and cl_source = 2, lower control limit for an individual x.

uclIx

Optional. Holds the upper control limit for individual x. If variable and cl_source = 2, upper control limit for an individual x.

clImr

Optional. Holds the center line for individual moving range. If variable and cl_source = 2, center line for an individual moving range.

lclImr

Optional. Holds the lower control limit for individual moving range. If variable and cl_source = 2, lower control limit for an individual moving range.

uclImr

Optional. Holds the upper control limit for individual moving range. If variable and cl_source = 2, upper control limit for an individual moving range.

clMa

Optional. Holds the center line for moving average. If variable and cl_source = 2, center line for a moving average.

lclMa

Optional. Holds the lower control limit for moving average. If variable and cl_source = 2, lower control limit for a moving average.

uclMa

Optional. Holds the upper control limit for moving average. If variable and cl_source = 2, upper control limit for a moving average.

clMr

Optional. Holds the center line for moving range. If variable and cl_source = 2, center line for a moving range.

lclMr

Optional. Holds the lower control limit for moving range. If variable and cl_source = 2, lower control limit for a moving range.

uclMr

Optional. Holds the upper control limit for moving range. If variable and cl_source = 2, upper control limit for a moving range.

clMs

Optional. Holds the center line for moving sigma. If variable and cl_source = 2, center line for a moving sigma.

lclMs

Optional. Holds the lower control limit for moving sigma If variable and cl_source = 2, lower control limit for a moving sigma.

uclMs

Optional. Holds the upper control limit for moving sigma. If variable and cl_source = 2, upper control limit for a moving sigma.

clP

Optional. Holds the center line for p. If attribute and cl_source = 2, center line for p chart.

lclP

Optional. Holds the lower control limit for p. If attribute and cl_source = 2, lower control limit for p chart.

uclP

Optional. Holds the upper control limit for p. If attribute and cl_source = 2, upper control limit for p chart.

clNp

Optional. Holds the center line for np. If attribute and cl_source = 2, center line for np chart.

lclNp

Optional. Holds the lower control limit for np. If attribute and cl_source = 2, lower control limit for np chart.

uclNp

Optional. Holds the upper control limit for np. If attribute and cl_source = 2, upper control limit for np chart.

clC

Optional. Holds the center line for c. If attribute and cl_source = 2, center line for c chart.

lclC

Optional. Holds the lower control limit for c. If attribute and cl_source = 2, lower control limit for c chart.

uclC

Optional. Holds the upper control limit for c. If attribute and cl_source = 2, upper control limit for c chart.

clU

Optional. Holds the center line for u. If attribute and cl_source = 2, center line for u chart.

lclU

Optional. Holds the lower control limit for u. If attribute and cl_source = 2, lower control limit for u chart.

uclU

Optional. Holds the upper control limit for u. If attribute and cl_source = 2, upper control limit for u chart.

defaultChart

Optional. Holds the default_chart of the characteristic.

2 = Xbar + Range

3 = Xbar + Sigma

5 (default) = IX + MR

7 = MA + Range

8 = MA + Sigma

16 = p

17 = np

18 = u

19 = c

20 = DPMO (coding per QI Analyst).

automatedColl

Optional. Holds an enumeration that indicates whether this characteristic can be collected automatically.

0 = No

1 = Yes

2 = Use the characteristic's automated_coll setting (the default)

timeInterval

Optional. If sample size > 1 and automated_coll is Yes, holds the interval between the measurements.

Note that this is a default for the characteristic, which can be overridden independently at each SRO.

timeIntUnit

Optional. Holds an enumeration that indicates the units of the time interval between the measurements.

0 = seconds

1 = minutes

2 = hours

lastEditBy

Optional. Holds the ID of a user who added or last updated a sample plan record.

lastEditAt

Optional. Holds the datetime when a characteristic record was added or last updated.

Return Value

Returns a DataSet that contains all the records in the Qm_Spec_Char_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 that is the ID of the specification.
qm_spec_name	A string that is the name of the specification.
char_id	An integer that is the ID of the characteristic.
char_name	A string that is the name of the characteristic.
char_desc	A string that is the description of the characteristic.
type	An integer that indicates the type of the characteristic: 0 = variable 1 = binary 2 = counted
target	A float that is the target value for this characteristic.
lsv	A float that is the lower specification value.
usv	A float that is the upper specification value.
lsv_is_offset	A Boolean flag that indicates whether lsv is the difference between target and lsl. That is, lsv is not equal to lower spec limit (lsl) but is an offset.
usv_is_offset	A Boolean flag that indicates whether usv is the difference between usl and target. That is, usv is not equal to upper spec limit (usl) but is an offset.
lsv_offset_is_pct	A Boolean flag that, if the lsv value is an offset, indicates whether it is a percentage value.
usv_offset_is_pct	A Boolean flag that, if the usv value is an offset, indicates whether it is a percentage value
lsl	A float that is the lower specification limit.
usl	A float that is the upper specification limit.
lrv	A float that is the lower reasonable value.
urv	A float that is the upper reasonable value.
lrv_is_mult	A Boolean flag that indicates whether lrv is a multiplier for the difference between the lower spec limits and target, to find the offset from target for lrl. If not, lrv = lower reasonable limit (an absolute value).
urv_is_mult	A Boolean flag that indicates whether urv is a multiplier for the difference between the upper spec limits and target, to find the offset from target for url. If not, urv = upper reasonable limit (an absolute value).
severity_cd	An integer that is the severity of the characteristic, from the Characteristic table.
plan_id	An integer that is the ID of the plan.
sample_size_source	An integer that is the source of the sample size.
normal_sample_size	An integer that is the normal number of measurements in a sample.
minimum_sample_size	An integer that is the minimum number of measurements in a sample.
maximum_sample_size	An integer that is the maximum number of measurements in a sample.
cl_source	An integer that indicates the control limit source. 0 = automatically calculate from data (default) 1 = compute from standard mean and standard deviation values (if variable) or compute from standard p, np average proportion and standard c, u average number per unit values (if attribute) 2 = use preset values.
samples_for_cl	An integer that is the number of samples to use for the calculation of control limits.
samples_before_cl	An integer that is the number of samples required before control limits are calculated.
std_avg	A float that is the standard average value. If cl_source = 1 and type is variable, this is the standard mean. If type is binary attribute, this is the standard p, np average proportion value. If type is counted attribute, this is the standard c, u average number per unit value.
std_avg_is_target	A Boolean flag that indicates whether to use the target as the standard instead of the std_avg value.
std_deviation	A float that is the standard deviation value.
cl_xbar	A float that is the center line for xbar chart.
lcl_xbar	A float that is the lower control limit for xbar chart.
ucl_xbar	A float that is the upper control limit for xbar chart.
cl_range	A float that is the center line for range.
lcl_range	A float that is the lower control limit for range.
ucl_range	A float that is the upper control limit for range.
cl_sigma	A float that is the center line for sigma.
lcl_sigma	A float that is the lower control limit for sigma.
ucl_sigma	A float that is the upper control limit for sigma.
cl_ix	A float that is the center line for individual x.
lcl_ix	A float that is the lower control limit for individual x.
ucl_ix	A float that is the upper control limit for individual x.
cl_imr	A float that is the center line for individual moving range.
lcl_imr	A float that is the lower control limit for individual moving range.
ucl_imr	A float that is the upper control limit for individual moving range.
cl_ma	A float that is the center line for moving average.
lcl_ma	A float that is the lower control limit for moving average.
ucl_ma	A float that is the upper control limit for moving average.
cl_mr	A float that is the center line for moving range.
lcl_mr	A float that is the lower control limit for moving range.
ucl_mr	A float that is the upper control limit for moving range.
cl_ms	A float that is the center line for moving sigma.
lcl_ms	A float that is the lower control limit for moving sigma.
ucl_ms	A float that is the upper control limit for moving sigma.
cl_p	A float that is the center line for p.
lcl_p	A float that is the lower control limit for p.
ucl_p	A float that is the upper control limit for p.
cl_np	A float that is the center line for np.
lcl_np	A float that is the lower control limit for np.
ucl_np	A float that is the upper control limit for np.
cl_c	A float that is the center line for c.
lcl_c	A float that is the lower control limit for c.
ucl_c	A float that is the upper control limit for c.
cl_u	A float that is the center line for u.
lcl_u	A float that is the lower control limit for u.
ucl_u	A float that is the upper control limit for u.
default_chart	An integer that indicates the default chart for the characteristic. 2 = Xbar + Range 3 = Xbar + Sigma 5 = IX + MR (the default) 7 = MA + Range 8 = MA + Sigma 16 = p 17 = np 18 = u 19 = c 20 = DPMO (coding per QI Analyst)
automated_coll	An integer that is an enumeration that indicates whether this characteristic can be collected automatically. 0 = No 1 = Yes 2 = Use the characteristic's automated_coll setting (the default)
time_interval	If sample size > 1 and automated_coll is Yes, an integer that is the time interval between the measurements.
time_int_unit	An integer that is an enumeration that indicates the units of the time interval between the measurements. 0 = seconds 1 = minutes 2 = hours
display_seq	An integer that is the value for the display sequence of the specification-characteristic link (see Remarks).
last_edit_comment	A string that is the 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 value that indicates when the record was added or last updated.
row_id	An integer that is the unique row ID of the record, from the Qm_Spec_Char_Link table.

MES Stateless API