MES Stateless API

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

Save PDF

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

Save PDF

Last UpdatedNov 06, 2025
3 minute read

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

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal woId As String, _
   ByVal operId As String, _
   ByVal seqNo As Nullable(Of Integer), _
   ByVal stepNo As Nullable(Of Integer), _
   ByVal specId As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim woId As String
Dim operId As String
Dim seqNo As Nullable(Of Integer)
Dim stepNo As Nullable(Of Integer)
Dim specId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = JobSpec.GetAll(woId, operId, seqNo, stepNo, specId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string woId,
   string operId,
   Nullable<int> seqNo,
   Nullable<int> stepNo,
   string specId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

woId: Optional filter parameter. Holds the ID of a work order.
operId: Optional filter parameter. Holds the ID of an operation.
seqNo: Optional filter parameter. Holds the operation sequence number of the job.
stepNo: Optional filter parameter. Holds the number of the step with which a specification is associated.
specId: Optional filter parameter. Holds a specification ID.
lastEditBy: Optional filter parameter. Holds the ID of a user who added or last updated a job specification record.
lastEditAt: Optional filter parameter. Holds the date and time when a job specification record was added or last updated.

Return Value

Returns a DataSet that contains records for all the job specifications that satisfy the specified filters. The returned records include columns from the Job, Job_Spec, and Spec tables. If no matching job specifications are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

ColumnName	Description
wo_id	A string that is the ID of the work order.
oper_id	A string that is the ID of the operation.
seq_no	An integer that is the operation sequence number of the job.
step_no	An integer that is the number of the step with which the specification is associated.
spec_id	A string that is the ID of the specification.
spec_value	A string that is the planned specification value.
act_spec_value	A string that is the actual specification value.
assoc_file	A string that is the path and file name of the file associated with the specification.
assoc_file_type	A string that is the file type of the file associated with the specification.
comments	A string that is the comments or instructions for the operator regarding the specification.
min_value	A string that is the minimum acceptable value for the specification. The default value is null.
max_value	A string that is the maximum acceptable value for the specification. The default value is null.
access_level	An integer that is the security access level for modifying the specification. The default value is null.
spec_desc	A string that is the description of the job specification.
grp_id	A string that is the ID of the spec group of which the specification is a member, from the Spec table.
units	A string that is the unit of measure for the specification value, from the Spec table.
spare1	A string that is the contents of the user-defined spare1 field, from the Spec table.
spare2	A string that is the contents of the user-defined spare2 field, from the Spec table.
spare3	A string that is the contents of the user-defined spare3 field, from the Spec table.
spare4	A string that is the contents of the user-defined spare4 field, from the Spec table.
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.
data_type	An integer that is an enumeration that indicates the data type of the specification, from the Spec table. 0 = string (the default) 1 = floating point number
display_seq	An integer that is the specifications display sequence number. The display sequence numbers are used to determine the order of specifications with their specification group when they are listed in the user interface. From the Spec table.

MES Stateless API