GetAll Method (Characteristic)

• Visual Basic
• C#

'Declaration
 
Public Shared Function GetAll( _
   ByVal charId As Nullable(Of Integer), _
   ByVal charName As String, _
   ByVal charDesc As String, _
   ByVal type As Nullable(Of Integer), _
   ByVal uomId As Nullable(Of Integer), _
   ByVal severityCd As Nullable(Of Integer), _
   ByVal defaultChart As Nullable(Of Integer), _
   ByVal automatedColl As Nullable(Of Boolean), _
   ByVal timeInterval As Nullable(Of Integer), _
   ByVal timeIntUnit As Nullable(Of Integer), _
   ByVal numberDecimals 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 numberDefectOpp As Nullable(Of Integer), _
   ByVal movAvgSpan As Nullable(Of Integer), _
   ByVal sigmaEst As Nullable(Of Integer), _
   ByVal trendLimits As Nullable(Of Boolean), _
   ByVal useStdErr As Nullable(Of Boolean), _
   ByVal clSource As Nullable(Of Integer), _
   ByVal samplesForCl As Nullable(Of Integer), _
   ByVal stdAvg As Nullable(Of Double), _
   ByVal stdAvgIsTarget As Nullable(Of Boolean), _
   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 fittest As Nullable(Of Integer), _
   ByVal histCapabilitySigma As Nullable(Of Integer), _
   ByVal filterByEntId As Nullable(Of Boolean), _
   ByVal filterByItemId As Nullable(Of Boolean), _
   ByVal filterByWoId As Nullable(Of Boolean), _
   ByVal filterByOperId As Nullable(Of Boolean), _
   ByVal filterByProcessId As Nullable(Of Boolean), _
   ByVal filterBySegmentReqId As Nullable(Of Boolean), _
   ByVal filterBySegmentRespId As Nullable(Of Boolean), _
   ByVal filterBySpare1 As Nullable(Of Boolean), _
   ByVal filterBySpare2 As Nullable(Of Boolean), _
   ByVal filterBySpare3 As Nullable(Of Boolean), _
   ByVal filterBySpare4 As Nullable(Of Boolean), _
   ByVal spare1 As String, _
   ByVal spare2 As String, _
   ByVal spare3 As String, _
   ByVal spare4 As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim charId As Nullable(Of Integer)
Dim charName As String
Dim charDesc As String
Dim type As Nullable(Of Integer)
Dim uomId As Nullable(Of Integer)
Dim severityCd As Nullable(Of Integer)
Dim defaultChart As Nullable(Of Integer)
Dim automatedColl As Nullable(Of Boolean)
Dim timeInterval As Nullable(Of Integer)
Dim timeIntUnit As Nullable(Of Integer)
Dim numberDecimals 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 numberDefectOpp As Nullable(Of Integer)
Dim movAvgSpan As Nullable(Of Integer)
Dim sigmaEst As Nullable(Of Integer)
Dim trendLimits As Nullable(Of Boolean)
Dim useStdErr As Nullable(Of Boolean)
Dim clSource As Nullable(Of Integer)
Dim samplesForCl As Nullable(Of Integer)
Dim stdAvg As Nullable(Of Double)
Dim stdAvgIsTarget As Nullable(Of Boolean)
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 fittest As Nullable(Of Integer)
Dim histCapabilitySigma As Nullable(Of Integer)
Dim filterByEntId As Nullable(Of Boolean)
Dim filterByItemId As Nullable(Of Boolean)
Dim filterByWoId As Nullable(Of Boolean)
Dim filterByOperId As Nullable(Of Boolean)
Dim filterByProcessId As Nullable(Of Boolean)
Dim filterBySegmentReqId As Nullable(Of Boolean)
Dim filterBySegmentRespId As Nullable(Of Boolean)
Dim filterBySpare1 As Nullable(Of Boolean)
Dim filterBySpare2 As Nullable(Of Boolean)
Dim filterBySpare3 As Nullable(Of Boolean)
Dim filterBySpare4 As Nullable(Of Boolean)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = Characteristic.GetAll(charId, charName, charDesc, type, uomId, severityCd, defaultChart, automatedColl, timeInterval, timeIntUnit, numberDecimals, sampleSizeSource, normalSampleSize, minimumSampleSize, maximumSampleSize, numberDefectOpp, movAvgSpan, sigmaEst, trendLimits, useStdErr, 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, fittest, histCapabilitySigma, filterByEntId, filterByItemId, filterByWoId, filterByOperId, filterByProcessId, filterBySegmentReqId, filterBySegmentRespId, filterBySpare1, filterBySpare2, filterBySpare3, filterBySpare4, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> charId,
   string charName,
   string charDesc,
   Nullable<int> type,
   Nullable<int> uomId,
   Nullable<int> severityCd,
   Nullable<int> defaultChart,
   Nullable<bool> automatedColl,
   Nullable<int> timeInterval,
   Nullable<int> timeIntUnit,
   Nullable<int> numberDecimals,
   Nullable<int> sampleSizeSource,
   Nullable<int> normalSampleSize,
   Nullable<int> minimumSampleSize,
   Nullable<int> maximumSampleSize,
   Nullable<int> numberDefectOpp,
   Nullable<int> movAvgSpan,
   Nullable<int> sigmaEst,
   Nullable<bool> trendLimits,
   Nullable<bool> useStdErr,
   Nullable<int> clSource,
   Nullable<int> samplesForCl,
   Nullable<double> stdAvg,
   Nullable<bool> 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> fittest,
   Nullable<int> histCapabilitySigma,
   Nullable<bool> filterByEntId,
   Nullable<bool> filterByItemId,
   Nullable<bool> filterByWoId,
   Nullable<bool> filterByOperId,
   Nullable<bool> filterByProcessId,
   Nullable<bool> filterBySegmentReqId,
   Nullable<bool> filterBySegmentRespId,
   Nullable<bool> filterBySpare1,
   Nullable<bool> filterBySpare2,
   Nullable<bool> filterBySpare3,
   Nullable<bool> filterBySpare4,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

charId

Optional. An integer value to filter the dataset by characteristic identifier.

charName

Optional. A string which identifies the name of the characteristic from the Characteristic table.

charDesc

Optional. A String that contains the description of the characteristic from the Characteristic table.

type

Optional. A String that contains the type of the characteristic from the Characteristic table. 0 (default) = variable, 1 = binary attribute, 2 = counted attribute.

uomId

Optional. An integer value to filter the dataset by the unit of measure for the characteristic.

severityCd

Optional. An integer value to filter the dataset by 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

defaultChart

Optional. An integer value to filter the dataset by 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. A boolean value to filter the dataset by the automated_coll value which flags if this characteristic can be collected automatically. Default = no

timeInterval

Optional. An integer value to filter the dataset by the interval between the measurements. If sample size > 1 and automated_coll is Yes, the interval between measurements. Note this is a default for the characteristic, which can be overridden independently at each SRO.

timeIntUnit

Optional. An integer value to filter the dataset by the units of time interval. 0 = seconds, 1 = minutes, 2 = hours

numberDecimals

Optional. An integer value to filter the dataset by the number of decimals which are displayed. Default = 0.

sampleSizeSource

Optional. An integer value to filter the dataset by 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. An integer value to filter the dataset by 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. An integer value to filter the dataset by the minimum number of measurements in a sample. default = 1

maximumSampleSize

Optional. An integer value to filter the dataset by the maximum number of measurements in a sample.

numberDefectOpp

Optional. An integer value to filter the dataset by the number of defect opportunities per piece for counted attribute.

movAvgSpan

Optional. An integer value to filter the dataset by the number of subgroups to average for moving average charts.

sigmaEst

Optional. An integer value to filter the dataset by the sigma estimate. If variable, 0 = use tables, 1 = use std. dev.

trendLimits

Optional. A boolean value to filter the dataset by the trend limits. If variable, trend x-bar and IX limits Default = yes

useStdErr

Optional. A boolean value to filter the dataset by the flag standard error of regression. If trend_llimits = yes, use standard error of regression as sigma estimate Default = no

clSource

Optional. An integer value to filter the dataset by 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. An integer value to filter the dataset by 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. A double value to filter the dataset by 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. A boolean value whether to use the target instead of the std_avg value as the standard. If cl_source = 1, Default = yes

stdDeviation

Optional. A double value to filter the dataset by standard deviation value. If variable and cl_source = 1, the standard deviation value

clXbar

Optional. A float value to filter the dataset by center line for xbar chart. If variable and cl_source = 2, center line for xbar

lclXbar

Optional. A float value to filter the dataset by lower control limit for xbar chart. If variable and cl_source = 2, lower control limit for xbar

uclXbar

Optional. A float value to filter the dataset by upper control limit for xbar chart. If variable and cl_source = 2, upper control limit for xbar

clRange

Optional. A float value to filter the dataset by center line for range. If variable and cl_source = 2, center line for range

lclRange

Optional. A float value to filter the dataset by lower control limit for range. If variable and cl_source = 2, lower control limit for range

uclRange

Optional. A float value to filter the dataset by upper control limit for range. If variable and cl_source = 2, upper control limit for range

clSigma

Optional. A float value to filter the dataset by center line for sigma. If variable and cl_source = 2, center line for sigma

lclSigma

Optional. A float value to filter the dataset by lower control limit for sigma. If variable and cl_source = 2, lower control limit for sigma

uclSigma

Optional. A float value to filter the dataset by upper control limit for sigma. If variable and cl_source = 2, upper control limit for sigma

clIx

Optional. A float value to filter the dataset by center line for individual x. If variable and cl_source = 2, center line for individual x

lclIx

Optional. A float value to filter the dataset by lower control limit for individual x. If variable and cl_source = 2, lower control limit for individual x

uclIx

Optional. A float value to filter the dataset by upper control limit for individual x. If variable and cl_source = 2, upper control limit for individual x

clImr

Optional. A float value to filter the dataset by center line for individual moving range. If variable and cl_source = 2, center line for individual moving range

lclImr

Optional. A float value to filter the dataset by lower control limit for individual moving range. If variable and cl_source = 2, lower control limit for individual moving range

uclImr

Optional. A float value to filter the dataset by upper control limit for individual moving range. If variable and cl_source = 2, upper control limit for individual moving range

clMa

Optional. A float value to filter the dataset by center line for moving average. If variable and cl_source = 2, center line for moving average

lclMa

Optional. A float value to filter the dataset by lower control limit for moving average. If variable and cl_source = 2, lower control limit for moving average

uclMa

Optional. A float value to filter the dataset by upper control limit for moving average. If variable and cl_source = 2, upper control limit for moving average

clMr

Optional. A float value to filter the dataset by center line for moving range. If variable and cl_source = 2, center line for moving range

lclMr

Optional. A float value to filter the dataset by lower control limit for moving range. If variable and cl_source = 2, lower control limit for moving range

uclMr

Optional. A float value to filter the dataset by upper control limit for moving range. If variable and cl_source = 2, upper control limit for moving range

clMs

Optional. A float value to filter the dataset by center line for moving sigma. If variable and cl_source = 2, center line for moving sigma

lclMs

Optional. A float value to filter the dataset by lower control limit for moving sigma If variable and cl_source = 2, lower control limit for moving sigma

uclMs

Optional. A float value to filter the dataset by upper control limit for moving sigma. If variable and cl_source = 2, upper control limit for moving sigma

clP

Optional. A float value to filter the dataset by center line for p. If attribute and cl_source = 2, center line for p

lclP

Optional. A float value to filter the dataset by lower control limit for p. If attribute and cl_source = 2, lower control limit for p

uclP

Optional. A float value to filter the dataset by upper control limit for p. If attribute and cl_source = 2, upper control limit for p

clNp

Optional. A float value to filter the dataset by center line for np. If attribute and cl_source = 2, center line for np

lclNp

Optional. A float value to filter the dataset by lower control limit for np. If attribute and cl_source = 2, lower control limit for np

uclNp

Optional. A float value to filter the dataset by upper control limit for np. If attribute and cl_source = 2, upper control limit for np

clC

Optional. A float value to filter the dataset by center line for c. If attribute and cl_source = 2, center line for c

lclC

Optional. A float value to filter the dataset by lower control limit for c. If attribute and cl_source = 2, lower control limit for c

uclC

Optional. A float value to filter the dataset by upper control limit for c. If attribute and cl_source = 2, upper control limit for c

clU

Optional. A float value to filter the dataset by center line for u. If attribute and cl_source = 2, center line for u

lclU

Optional. A float value to filter the dataset by lower control limit for u. If attribute and cl_source = 2, lower control limit for u

uclU

Optional. A float value to filter the dataset by upper control limit for u. If attribute and cl_source = 2, upper control limit for u

fittest

Optional. An integer value to filter the dataset by the test to use for a goodness of fit. If variable, test to use for goodness of fit 0 = Shapiro-Wilk, 1 = Kolmogorov-Smirnov, 2 = Chi-Square, 3 = none

histCapabilitySigma

Optional. An integer value to filter the dataset by the Hist capability Sigma. 0 = estimate using R-Bar, 1 = estimate using S-Bar, 2 = use within-group variation

filterByEntId

Optional. A boolean value to filter the dataset by the filterByEntId which flags if the default dataset be limited by ent_id of current/last sample even if qm_spec has null ent_id. Default = No

filterByItemId

Optional. A boolean value to filter the dataset by the filterByItemId which flags if the default dataset be limited by item_id of current/last sample even if qm_spec has null item_id, item_class_id, and parent_item_class_id. Default = No

filterByWoId

Optional. A boolean value to filter the dataset by the filterByWoId which flags if the default dataset be limited by wo_id of current/last sample. Default = No

filterByOperId

Optional. A boolean value to filter the dataset by the filterByOperId which flags if the default dataset be limited by oper_id of current/last sample even if qm_spec has null oper_id. Default = No

filterByProcessId

Optional. A boolean value to filter the dataset by the filterByProcessId which flags if the default dataset be limited by process_id of current/last sample. Default = No

filterBySegmentReqId

Optional. A boolean value to filter the dataset by the filterBySegmentReqId which flags if the default dataset be limited by segment_requirement _id of current/last sample. Default = No

filterBySegmentRespId

Optional. A boolean value to filter the dataset by the filterBySegmentRespId which flags if the default dataset be limited by segment_response _id of current/last sample. Default = No

filterBySpare1

Optional. A boolean value to filter the dataset by the filterBySpare1 which flags if the default dataset be limited by the values in the spare1 field of current/last sample. Default = No

filterBySpare2

Optional. A boolean value to filter the dataset by the filterBySpare2 which flags if the default dataset be limited by the values in the spare2 field of current/last sample. Default = No

filterBySpare3

Optional. A boolean value to filter the dataset by the filterBySpare3 which flags if the default dataset be limited by the values in the spare3 field of current/last sample. Default = No

filterBySpare4

Optional. A boolean value to filter the dataset by the filterBySpare4 which flags if the default dataset be limited by the values in the spare4 field of current/last sample. Default = No

spare1

Optional. A string value to filter the dataset by a value defined by language term 5157.

spare2

Optional. A string value to filter the dataset by a value defined by language term 5158.

spare3

Optional. A string value to filter the dataset by a value defined by language term 5159.

spare4

Optional. A string value to filter the dataset by a value defined by language term 5160.

lastEditBy

Optional. A string value to filter the dataset by ID of the user who created or last modified this record.

lastEditAt

Optional. A datetime value to filter the dataset by the time that the row was last edited to retrieve information about.

Return Value