MES Stateless API

GetBySpecs Method

Save PDF

GetBySpecs Method

Save PDF

Last UpdatedNov 06, 2025
6 minute read

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

Syntax

'Declaration
 
Public Shared Function GetBySpecs( _
   ByVal specIds() As Integer _
) As DataSet

'Usage
 
Dim specIds() As Integer
Dim value As DataSet
 
value = QmSpecCharLink.GetBySpecs(specIds)

public static DataSet GetBySpecs( 
   int[] specIds
)

Parameters

specIds: Required. Holds an array of QM specification IDs.

Return Value

Returns a DataSet that contains all the records in the Qm_Spec_Char_Link table whose specification IDs match those provided in the array. 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	A Boolean flag that indicates whether this characteristic can be collected automatically.
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