MES Stateless API

GetAll Method (StdOperStepFile)

Save PDF

GetAll Method (StdOperStepFile)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal operId As String, _
   ByVal stepNo As Nullable(Of Integer), _
   ByVal assocFile As String, _
   ByVal assocFileType 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 assocFile As String
Dim assocFileType As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = StdOperStepFile.GetAll(operId, stepNo, assocFile, assocFileType, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string operId,
   Nullable<int> stepNo,
   string assocFile,
   string assocFileType,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

operId: Optional filter parameter. Holds the ID of the operation to which steps belong.
stepNo: Optional filter parameter. Holds a step number.
assocFile: Optional filter parameter. Holds the path and file name of the file associated with the standard operation step file.
assocFileType: Optional filter parameter. Holds the file extension of the file associated with the standard operation step file.
lastEditBy: Optional filter parameter. Holds the ID of a user who added or last updated a standard operation step file record.
lastEditAt: Optional filter parameter. Holds a date/time when a standard operation step file record was added or last updated.

Return Value

Returns a DataSet that contains all the records in the Std_Oper_Step_File 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.

ColumnName	Description
oper_id	A string that is the ID of the operation to which the step belongs.
step_no	An integer that is the step number.
assoc_file	A string that is path and file name of the associated file.
assoc_file_type	A string that is the file extension of the associated file. The file extension is pulled from the filename in the file_path column.
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/time that indicates when the record was added or last updated.

MES Stateless API