GetAll Method (Result)
- Last UpdatedMar 17, 2026
- 3 minute read
The GetAll() method retrieves one or more result records from the Result table, as specified by the filter parameters. Passing no filter parameters will retrieve all result records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal rowId As Nullable(Of Integer), _
ByVal sampleId As Nullable(Of Integer), _
ByVal charId As Nullable(Of Integer), _
ByVal valueNo As Nullable(Of Integer), _
ByVal resultValue As Nullable(Of Double), _
ByVal actSampleSize As Nullable(Of Integer), _
ByVal createdBy As String, _
ByVal createdAt As Nullable(Of Date), _
ByVal superseded As Nullable(Of Integer), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim rowId As Nullable(Of Integer)
Dim sampleId As Nullable(Of Integer)
Dim charId As Nullable(Of Integer)
Dim valueNo As Nullable(Of Integer)
Dim resultValue As Nullable(Of Double)
Dim actSampleSize As Nullable(Of Integer)
Dim createdBy As String
Dim createdAt As Nullable(Of Date)
Dim superseded As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Result.GetAll(rowId, sampleId, charId, valueNo, resultValue, actSampleSize, createdBy, createdAt, superseded, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> rowId,
Nullable<int> sampleId,
Nullable<int> charId,
Nullable<int> valueNo,
Nullable<double> resultValue,
Nullable<int> actSampleSize,
string createdBy,
Nullable<DateTime> createdAt,
Nullable<int> superseded,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- rowId
- Optional filter parameter. Holds the Row ID of the record being retrieved.
- sampleId
- Optional filter parameter. Holds the Identity of the sample.
- charId
- Optional filter parameter. Holds the Characteristic Id.
- valueNo
- Optional filter parameter. Holds the Value Number of the Subgroup.
- resultValue
- Optional filter parameter. Holds the Result Value of the Characteristic measured.
- actSampleSize
- Optional filter parameter. Holds the Actual Sample Size.
- createdBy
- Optional filter parameter. Holds the Identity of who created this value.
- createdAt
- Optional filter parameter. Holds the DateTime of when the Value was entered.
- superseded
- Optional filter parameter. Holds the value as to whether this result has been changed.
- lastEditBy
- Optional filter parameter. Holds the Identity of a user who added or last updated a record
- lastEditAt
- Optional filter parameter. Holds the DateTime that this record was added or updated.
Return Value
Returns a DataSet that contains records from the Result 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. |
| sample_name | A string that is the sample name. |
| char_id | An integer that is the characteristic ID. |
| char_name | A string that is the characteristic name. |
| value_no | An integer that is the number that identifies the value in the subgroup. |
| result_value | A double that is the result value of the measured characteristic. |
| act_sample_size | An integer that is the actual sample size. |
| created_by | A string that is the ID of the user who entered the value. |
| created_at_utc | A datetime that is the date and time when the value was entered, in UTC. |
| created_at_local | A datetime that is the date and time when the value was entered, in the local time of the entity at which the sample was pulled. |
| created_at | A datetime that is the date and time when the value was entered, in the local time of the time zone that was specified in the tz_id parameter in the call header or URL. If the tz_id parameter was not provided or was not valid, then the time is in UTC. |
| superseded |
An integer that is an enumeration that indicates whether this result record has been superseded by another result record for the same sample ID, characteristic ID, and value number combination. 0 = No (the default) 1 = Superseded |
| 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. |
| row_id | An integer that is the unique row ID of the record, from the Result table. |