GetAll Method (SampleCharLink)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAll() method retrieves one or more cample_char_link records from the Sample_Char_Link table, as specified by the filter parameters. Passing no filter parameters will retrieve all sample records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal sampleId As Nullable(Of Integer), _
ByVal charId As Nullable(Of Integer), _
ByVal qmSpecId As Nullable(Of Integer), _
ByVal note As String, _
ByVal causeId As Nullable(Of Integer), _
ByVal controlMove As Nullable(Of Boolean), _
ByVal ignoreSample As Nullable(Of Boolean), _
ByVal equipment As String, _
ByVal actualSampleSize As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim sampleId As Nullable(Of Integer)
Dim charId As Nullable(Of Integer)
Dim qmSpecId As Nullable(Of Integer)
Dim note As String
Dim causeId As Nullable(Of Integer)
Dim controlMove As Nullable(Of Boolean)
Dim ignoreSample As Nullable(Of Boolean)
Dim equipment As String
Dim actualSampleSize As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = SampleCharLink.GetAll(sampleId, charId, qmSpecId, note, causeId, controlMove, ignoreSample, equipment, actualSampleSize, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> sampleId,
Nullable<int> charId,
Nullable<int> qmSpecId,
string note,
Nullable<int> causeId,
Nullable<bool> controlMove,
Nullable<bool> ignoreSample,
string equipment,
Nullable<int> actualSampleSize,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- sampleId
- Optional filter parameter. Holds the Identity of the sample.
- charId
- Optional filter parameter. Holds the Characteristic Id.
- qmSpecId
- Optional filter parameter. Holds the Specification Id from which the sample was generated.
- note
- Optional filter parameter. Holds a text note about this sample for this characteristic.
- causeId
- Optional filter parameter. Holds the Cause Id for this characteristic of this sample.
- controlMove
- Optional filter parameter. Holds the Boolean value as to whether there was a change to an environmental factor for this sample that would render old control limits obsolete. Default = No.
- ignoreSample
- Optional filter parameter. Holds the Boolean value as to whether this sample should be ignored when calculating statistics and run rule violations for this characteristic. Default = No
- equipment
- Optional filter parameter. Holds the equipment used to make the measurements for this characteristic for this sample.
- actualSampleSize
- Optional filter parameter. Holds the Actual Sample (subgroup) size if not recording individual results.
- lastEditBy
- Optional filter parameter. Holds the ID of a user who added or last updated a sample record.
- lastEditAt
- Optional filter parameter. Holds the datetime that this record was added.
Return Value
Returns a DataSet that contains records from the Sample_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 |
|---|---|
| sample_id | An integer that is the sample ID. |
| char_id | An integer that is the characteristic ID. |
| qm_spec_id | An integer that is the ID of the specification from which the sample was generated. |
| note | A string that is the note about this sample for this characteristic. |
| cause_id | An integer that is the ID of the cause for this characteristic of this sample. |
| control_move | A Boolean that indicates whether there was a change to an environmental factor for this sample that would render old control limits obsolete. |
| ignore_sample | A Boolean that indicates whether this sample should be ignored when calculating statistics and run rule violations for this characteristic. |
| equipment | A string that is the equipment used to make the measurements for this characteristic for this sample. |
| standard_dev | A double that is the standard deviation value for the characteristic. |
| mean | A double that is the mean value for the characteristic. |
| range | A double that is the range value for the characteristic. |
| act_sample_size | An integer that is the actual sample size. |
| 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 that is the date and time, in UTC, when the record was added or last updated. |