MES Stateless API

GetAll Method (StdOperStep)

Save PDF

GetAll Method (StdOperStep)

Save PDF

Last UpdatedNov 06, 2025
6 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal operId As String, _
   ByVal stepNo As Nullable(Of Integer), _
   ByVal stepSeq As Nullable(Of Integer), _
   ByVal stepName As String, _
   ByVal stepDesc As String, _
   ByVal actionType As Nullable(Of Integer), _
   ByVal completeCond As Nullable(Of Integer), _
   ByVal allowBypass As Nullable(Of Boolean), _
   ByVal enterData As Nullable(Of Boolean), _
   ByVal stepGrpId As Nullable(Of Integer), _
   ByVal spcChar As String, _
   ByVal formName As String, _
   ByVal dataLogGrpId As Nullable(Of Integer), _
   ByVal controlType As Nullable(Of Integer), _
   ByVal spare1 As String, _
   ByVal spare2 As String, _
   ByVal spare3 As String, _
   ByVal spare4 As String, _
   ByVal spare5 As String, _
   ByVal spare6 As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim operId As String
Dim stepNo As Nullable(Of Integer)
Dim stepSeq As Nullable(Of Integer)
Dim stepName As String
Dim stepDesc As String
Dim actionType As Nullable(Of Integer)
Dim completeCond As Nullable(Of Integer)
Dim allowBypass As Nullable(Of Boolean)
Dim enterData As Nullable(Of Boolean)
Dim stepGrpId As Nullable(Of Integer)
Dim spcChar As String
Dim formName As String
Dim dataLogGrpId As Nullable(Of Integer)
Dim controlType As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim spare5 As String
Dim spare6 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = StdOperStep.GetAll(operId, stepNo, stepSeq, stepName, stepDesc, actionType, completeCond, allowBypass, enterData, stepGrpId, spcChar, formName, dataLogGrpId, controlType, spare1, spare2, spare3, spare4, spare5, spare6, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string operId,
   Nullable<int> stepNo,
   Nullable<int> stepSeq,
   string stepName,
   string stepDesc,
   Nullable<int> actionType,
   Nullable<int> completeCond,
   Nullable<bool> allowBypass,
   Nullable<bool> enterData,
   Nullable<int> stepGrpId,
   string spcChar,
   string formName,
   Nullable<int> dataLogGrpId,
   Nullable<int> controlType,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string spare5,
   string spare6,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

operId: Optional filter parameter. Holds the ID of an operation to which the step(s) being retrieved belong.
stepNo: Optional filter parameter. Holds the number of an operation step.
stepSeq: Optional filter parameter. Holds the sequence to perform operation steps. If the sequence is the same, steps can be done concurrently.
stepName: Optional filter parameter. Holds the name of an operation step.
stepDesc: Optional filter parameter. Holds the description for an operation step.
actionType: Optional filter parameter. Holds an integer that indicates the action to be performed by a step.

0 = Normal (the default)

1 = Log data

2 = Add production

3 = Add consumption

4 = Operator acknowledge

5 = Enter from data

6 = Enter SPC data
completeCond: Optional filter parameter. Holds an integer that indicates the condition to complete a step.

2 = Standard time elapses

3 = Operator completes manually (the default)

4 = Message is dismissed (only if actionType is equal to 4)
allowBypass: Optional filter parameter. Holds a flag that specifies whether the user can bypass a step.
enterData: Optional filter parameter. Holds a flag that specifies whether data entry is required at a step.
stepGrpId: Optional filter parameter. Holds the ID of a step group.
spcChar: Optional filter parameter. Holds the SPC characteristic to be collected at a step.
formName: Optional filter parameter. Holds the name of the form for a step.
dataLogGrpId: Optional filter parameter. Holds the ID of the data log group for a step.
controlType: Optional filter parameter. Holds an integer that indicates the control type.

0 = text box, for storing any string (the default)

1 = text box, for storing an analog value

2 = text box, for storing a datetime

3 = check box

4 = radio buttons

5 = drop-down list
spare1: Optional filter parameter. Holds the contents of a user-defined spare1 field.
spare2: Optional filter parameter. Holds the contents of a user-defined spare2 field.
spare3: Optional filter parameter. Holds the contents of a user-defined spare3 field.
spare4: Optional filter parameter. Holds the contents of a user-defined spare4 field.
spare5: Optional filter parameter. Holds the contents of a user-defined spare5 field.
spare6: Optional filter parameter. Holds the contents of a user-defined spare6 field.
lastEditBy: Optional filter parameter. Holds the ID of a user who added or last updated a standard operation step record.
lastEditAt: Optional filter parameter. Holds the date/time when a standard operation step record was added or last updated.

Return Value

Returns a DataSet that contains records for all the standard operation steps that satisfy the specified filters. The returned records include columns from the Oper_Step_Grp, Oper, Process, and Std_Oper_Step tables. If no matching standard operation steps are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
processId	A string that is the ID of the process.
operId	A string that is the ID of the operation.
step_no	An integer that is the number of the operation step.
step_seq	An integer that is the sequence for this step.
step_name	A string that is the name of the operation step.
step_desc	A string that is the description for this step
action_type	An integer that is the action type. Refer to the description for the actionType parameter above.
std_time	A double that is the standard time for this step.
complete_cond	An integer that is the condition to complete this step. Refer to the description for the completeCond parameter above.
allow_bypass	A Boolean that is a flag that specifies whether the user can by-pass this step.
enter_data	A Boolean that is a flag that specifies whether data entry is required at this step.
step_grp_id	An integer that is the ID of the step group.
step_grp_desc	A string that is the description for this step group.
spc_char	A string that is the SPC characteristic which is collected at this step.
form_name	A string that is the name of the form for this step.
data_log_grp_id	An integer that is the ID of the data log group for this step.
reqd_rep_pct	A double -precision floating point number that is the percentage of lots or sublots for which this step must be done.
control_type	An integer that is the control type. Refer to the description for the controlType parameter above.
high_limit	A double that is the maximum limit of the control type. The default is null.
low_limit	A double that is the minimum limit of the control type. The default is null.
limit_warning	Applicable if controlType = 1. A Boolean that is a flag that indicates whether a warning message should be displayed when the limit has been exceeded. If set to true and the entry exceeds the limit, a warning message is displayed but the entry is allowed. If set to false and the entry exceeds the limit, the entry is not allowed. The default is false.
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.
spare5	A string that is the contents of the user-defined spare5 field.
spare6	A string that is the contents of the user-defined spare6 field.
oper_desc	A string that is the description of the operation.
process_desc	A string that is the description of the process.
step_grp_seq	A string that is the sequence of the step group.
repeatability	A Boolean that is a flag that, if false, indicates whether this step is done once per operation (e.g., a setup step for the operation) or, if true, for every lot produced during the operation.
can_log_data	An integer that acts as a Boolean flag to indicate whether the step can log data.
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 datetime 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.
step_grp_last_edit_at	A datetime that indicates when the associated step group record was created or last modified.
row_id	An integer that is the row ID of the record.

MES Stateless API