MES Stateless API

GetAll Method (SystemAttribute)

Save PDF

GetAll Method (SystemAttribute)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal attributeId As Nullable(Of Integer), _
   ByVal attributeValue As String, _
   ByVal groupId As Nullable(Of Integer), _
   ByVal editType As Nullable(Of Integer), _
   ByVal requiredLicenses As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim attributeId As Nullable(Of Integer)
Dim attributeValue As String
Dim groupId As Nullable(Of Integer)
Dim editType As Nullable(Of Integer)
Dim requiredLicenses As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = SystemAttribute.GetAll(attributeId, attributeValue, groupId, editType, requiredLicenses, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> attributeId,
   string attributeValue,
   Nullable<int> groupId,
   Nullable<int> editType,
   string requiredLicenses,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

attributeId

Optional filter parameter. Holds the ID of a system attribute.

attributeValue

Optional filter parameter. Holds the value of a system attribute.

groupId

Optional filter parameter. Holds the ID a group to which the attributes that are being retrieved belong.

editType

Optional filter parameter. Holds an enumeration that indicates the data type of the attribute:

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)

12 = long string (> 80 characters)

requiredLicenses

Optional filter parameter. Holds the certification associated to a data log group.

lastEditBy

Optional filter parameter. Holds the name of the user who added or last changed a system attribute record.

lastEditAt

Optional filter parameter. Holds a date/time of when a system attribute record was added or last changed.

Return Value

Returns a DataSet that contains the records in the System_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
attr_id	An integer that is the ID of the system attribute.
attr_desc	A string that is the description of the system attribute.
attr_value	A string that is the value of the system attribute.
grp_id	An integer that is the ID of the attribute group to which the attribute belongs.
attr_seq	An integer that is the sequence number of the attribute within its group.
edit_type	An enumeration that indicates the data type of the attribute: 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) 12 = long string (> 80 characters)
attr_constraints	A string that is the extra editing information. For drop-down lists, it contains the choices for the list separated by colons (:). For numeric values, it may contain the minimum and maximum values separated by colons. For edit type 13, it contains the table name, display column name, value column name, an optional Where clause, and a optional nullable indicator, all separated by colons.
reqd_lic	A string that is the licenses required for the system attribute to be editable. This column is null if the attribute requires no particular license. If the column has a value, the format is one or more product numbers joined by “+” for AND or “\|” for OR, and it is to be evaluated from left to right.
category	A string that is the category of this data collection group from the data_entry_sched.category column.
last_edit_comment	A string that contains comments about why the record was changed.
last_edit_by	A string that is the ID of the user who added or last updated this record.
last_edit_at	A date/time that indicates when the record was added or last updated.

MES Stateless API