MES Stateless API

GetAll Method (JobBomStep)

Save PDF

GetAll Method (JobBomStep)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

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

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

Parameters

woId: Optional filter parameter. Holds the work order ID.
operId: Optional filter parameter. Holds the operation ID.
seqNo: Optional filter parameter. Holds the operation sequence number of the job.
bomPos: Optional filter parameter. Holds the BOM position for a job.
stepNo: Optional filter parameter. Holds the step number for a job.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last changed a job BOM step record.
lastEditAt: Optional filter parameter. Holds the date/time when a job BOM step record was added or last changed.

Return Value

Returns a DataSet that contains records for all the job BOM step items that satisfy the specified filters. The returned records include columns from the Job_Bom_Step, Job_Step, and Job_Bom tables. If no matching job BOM step records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
wo_id	A string that is the work order ID for the job.
oper_id	A string that is the ID of the operation.
seq_no	An integer that is the sequence number for the job.
bom_pos	An integer that is the BOM position for the job.
step_no	An integer that is the step number for the job.
qty_per_parent_item	A double number that is the item quantity for the parent item.
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.
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