GetByQMSpec Method
- Last UpdatedNov 06, 2025
- 2 minute read
The GetByQMSpec() method retrieves a set of characteristic records, which match the filtered dataset, from the characteristic table. The records are retrieved based on the list of the QM Specifications IDs that are passed.
'Declaration
Public Shared Function GetByQMSpec( _
ByVal qmSpecIdList As String _
) As DataSet
'Usage
Dim qmSpecIdList As String
Dim value As DataSet
value = Characteristic.GetByQMSpec(qmSpecIdList)
public static DataSet GetByQMSpec(
string qmSpecIdList
)
Parameters
- qmSpecIdList
- Optional. Contains the list of QM Specification IDs from the qm_spec table. The IDs are separated by commas.
Return Value
Returns a DataSet that contains all the records in the Characteristic 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 |
|---|---|
|
char_id |
An integer that identifies the characteristic. |
|
char_name |
A string which identifies the name of the characteristic. |
|
char_desc |
A string that contains the description of the characteristic. |
|
type |
An integer which defines the type of characteristic. 0 (default) = variable, 1 = binary attribute, 2 = counted attribute. |
|
type_desc |
A string that describes the type of characteristic. |
|
uom_id |
An integer which identifies the unit of measure for the characteristic. |
|
uom_desc |
A string that describes the unit of measure for the characteristic. |
|
default_chart |
An integer which contains the default_chart of the characteristic. |
|
default_chart_desc |
A string that describes the default_chart of the characteristic. |
|
automated_coll |
A logical data type which is a flag if this characteristic can be collected automatically. |
|
automated_coll_desc |
A string that is a description of the logical data type specified by the automated_coll column. |
|
time_interval |
An integer value which contains the interval between the measurements. |
|
time_int_unit |
An integer value which contains the units of time interval. |
|
time_int_unit_desc |
A string that is the description of the units of time interval. |
|
num_decimals |
An integer value which contains the number of decimals which are displayed. |
|
sample_size_source |
An integer value which contains the source of the sample size. |
|
normal_sample_size |
An integer value which contains the normal number of measurements in a sample. |
|
minimum_sample_size |
An integer value which contains the minimum number of measurements in a sample. |
|
maximum_sample_size |
An integer value which contains the maximum number of measurements in a sample. |