MES Stateless API

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,String,String,Nullable<DateTime>) Method

Save PDF

GetAll(Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,Nullable<Int32>,String,String,String,Nullable<DateTime>) Method

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The GetAll() method retrieves one or more result attribute records from the Result_Attr table, as specified by the filter parameters. Passing no filter parameters will retrieve all result attribute records from the table.

This overload of the method includes the attrDescription filter parameter.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal sampleId As Nullable(Of Integer), _
   ByVal charId As Nullable(Of Integer), _
   ByVal valueNo As Nullable(Of Integer), _
   ByVal attrId As Nullable(Of Integer), _
   ByVal attrDescription As String, _
   ByVal attrValue As String, _
   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 valueNo As Nullable(Of Integer)
Dim attrId As Nullable(Of Integer)
Dim attrDescription As String
Dim attrValue As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = ResultAttr.GetAll(sampleId, charId, valueNo, attrId, attrDescription, attrValue, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> sampleId,
   Nullable<int> charId,
   Nullable<int> valueNo,
   Nullable<int> attrId,
   string attrDescription,
   string attrValue,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

sampleId: Optional filter parameter. Holds the sample ID.
charId: Optional filter parameter. Holds characteristic ID.
valueNo: Optional filter parameter. Holds the value of the subgroup
attrId: Optional filter parameter. Holds the attribute ID.
attrDescription: Optional filter parameter. Holds the description of attribute.
attrValue: Optional filter parameter. Holds the value of the attribute.
lastEditBy: Optional filter parameter. Holds the name of the user who added or last changed an entity record.
lastEditAt: Optional filter parameter. Holds a date/time of when an entity record was added or last changed.

Return Value

Returns a DataSet that contains records from the result_attr 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 ID of the sample to which the attribute applies.
char_id	A integer that is the ID of the characterisitc to which the attribute applies.
attr_id	An integer that is the attribute ID.
attr_value	A string that is the value for this attribute. The contents of this field depend on the data type specified in the data_type column.
notes	A string that is any notes for this attribute.
attr_desc	A string that is the description of the attribute. From the attr_desc column of the Attr table linked by the attr_id.
predefined	A Boolean that is a flag that specifies whether the attribute has a defined set of values in the Attr_Set table.
data_type	An integer that is an enumeration that indicates the data type of the attribute, from the Attr table. 0 = string (<= 80 characters; the default data type) 1 = drop-down list of values defined in the Attr_Set table 2 = integer 3 = currency 4 = color 5 = datetime 6 = floating point number 7 = percent 8 = check box 9 = non-editable 10 = time of day 11 = item reason (only if attr_grp = 3, the item attribute group) 12 = long string (> 80 characters)integer that identifies the data type for the attribute
entry_type	An integer that is an enumeration that indicates the type of entry to allow for this attribute, from the Attr table. 0 = value only (the default) 1 = notes only 2 = value and notes integer that indicates the type of entry to allow for this attribute
visible_in_queue	A Boolean that is a flag that specifies whether this attribute is visible in the queue. From the visible_in_queue column of the Attr table link by the attr_id.
visible_in_inv	A Boolean that is a flag that specifies whether this attribute is visible in the inventory. From the visible_in_inv column of the Attr table linked by the attr_id.
last_edit_comment	A string that holds any comments about why this record was added or last 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 when the record was added or last updated.

MES Stateless API