MES Stateless API

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

Save PDF

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

Save PDF

Last UpdatedNov 06, 2025
3 minute read

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

This overload of the method includes the specDescription filter parameter.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal specId As String, _
   ByVal specDescription As String, _
   ByVal grpId As String, _
   ByVal dataType As Nullable(Of Integer), _
   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 specId As String
Dim specDescription As String
Dim grpId As String
Dim dataType As Nullable(Of Integer)
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 = Spec.GetAll(specId, specDescription, grpId, dataType, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string specId,
   string specDescription,
   string grpId,
   Nullable<int> dataType,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

specId

Optional filter parameter. Holds the ID of a specification.

specDescription

Optional filter parameter. Holds the description of a specification.

grpId

Optional filter parameter. Holds the ID of a spec group of which the specifications being retrieved are members.

dataType

Optional filter parameter. Holds the enumeration that indicates the data type of the specification value.

0 = string (the default)

1 = floating point number

spare1

Optional filter parameter. Holds the contents of the user-defined spare1 field.

spare2

Optional filter parameter. Holds the contents of the user-defined spare2 field.

spare3

Optional filter parameter. Holds the contents of the user-defined spare3 field.

spare4

Optional filter parameter. Holds the contents of the user-defined spare4 field.

lastEditBy

Optional filter parameter. Holds the ID of the user who added or last updated a specification record.

lastEditAt

Optional filter parameter. Holds the date/time when a specification record was added or last updated.

Return Value

Returns a DataSet that contains all the records in the Spec 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
spec_id	A string that is the ID of the specification.
spec_desc	A string that is the description of the specification.
units	A string that is the unit of measure of the specification value.
grp_id	A string that is the ID of the specification group of which this specification is a member.
display_seq	An integer that is the display sequence in the user interface of the specificationwithin its spec group.
data_type	An integer that is an enumeration that indicates the data type of the specification. 0 = string (the default) 1 = floating point number
spare1	A string that is the contents of the user-defined spare1 field.
spare2	A string that is the contents of the user-defined spare2 field.
spare3	A string that is the contents of the user-defined spare3 field.
spare4	A string that is the contents of the user-defined spare4 field.
last_edit_comment	A string that contains 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 date and time that indicates when the record was added or last updated.
mod_id	The current modification ID of the record in the table. This ID is binary number that increments each time the record’s table row is modified. Optionally used for optimistic concurrency control when performing updates or deletes.

MES Stateless API