MES Stateless API

GetAll Method (BomItemOperSpec)

Save PDF

GetAll Method (BomItemOperSpec)

Save PDF

Last UpdatedNov 06, 2025
4 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal itemId As String, _
   ByVal verId As String, _
   ByVal bomPos As Nullable(Of Integer), _
   ByVal processId As String, _
   ByVal operId As String, _
   ByVal stepNo As Nullable(Of Integer), _
   ByVal specVerId As String, _
   ByVal specId As String, _
   ByVal specValue As String, _
   ByVal grpId As String, _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim itemId As String
Dim verId As String
Dim bomPos As Nullable(Of Integer)
Dim processId As String
Dim operId As String
Dim stepNo As Nullable(Of Integer)
Dim specVerId As String
Dim specId As String
Dim specValue As String
Dim grpId As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = BomItemOperSpec.GetAll(itemId, verId, bomPos, processId, operId, stepNo, specVerId, specId, specValue, grpId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   string itemId,
   string verId,
   Nullable<int> bomPos,
   string processId,
   string operId,
   Nullable<int> stepNo,
   string specVerId,
   string specId,
   string specValue,
   string grpId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

itemId: Optional filter parameter. Holds the ID of a BOM item.
verId: Optional filter parameter. Holds the ID of a BOM version.
bomPos: Optional filter parameter. Holds the BOM position (not necessarily in sequence).
processId: Optional filter parameter. Holds the ID of the process that is used to make an item.
operId: Optional filter parameter. Holds the ID of the operation in a process.
stepNo: Optional filter parameter. Holds the number of the step with which a specification is associated.
specVerId: Optional filter parameter. Holds the ID of a specification version.
specId: Optional filter parameter. Holds the ID of a specification.
specValue: Optional filter parameter. Holds a specification value.
grpId: Optional filter parameter. Holds the ID of the spec group of which a specification is a member.
lastEditBy: Optional filter parameter. Holds the ID of the user who added or last updated a BOM item operation specification record.
lastEditAt: Optional filter parameter. Holds the date/time when a BOM item operation specification record was added or last updated.

Return Value

Returns a DataSet that contains records for all the BOM item operation specifications that satisfy the specified filters. The returned records include columns from the Item, Spec, Process, and Bom_Item_Oper_Spec tables. If no matching BOM item operation specification records are found, an empty DataSet is returned.

The columns of the returned DataSet are described below.

Column Name	Description
item_id	A string that is the ID of the item being made.
ver_id	A string that is the ID of the BOM version.
bom_pos	An integer that is the BOM position.
process_id	A string that is the ID of the process used to make the item.
oper_id	A string that is the ID of the operation in the process.
step_no	An integer that is the number of the step with which the specification is associated.
spec_ver_id	A string that is the ID of the specification version.
spec_id	A string that is the ID of the specification.
spec_value	A string that is the value for this specification.
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 type of the file associated with the specification.
comments	A string that is the comments or instructions for the operator regarding this specification.
min_value	A string that is the minimum acceptable value for the specification.
max_value	A string that is the maximum acceptable value for the specification.
access_level	An integer that is the security access level for modifying this specification.
item_desc	A string that is description of the item, from the Item table.
process_desc	A string that is the description of the process, from the Process table.
grp_id	A string that is the ID of the spec group of which this specification is a member, from the Spec table.
spec_desc	A string that is the description of the specification, from the Spec table.
units	A string that is the description of 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.
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/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 value, from the Spec table. 0 = string (the default) 1 = floating point number

MES Stateless API