GetAll Method (BomVersion)
- Last UpdatedNov 06, 2025
- 3 minute read
The GetAll() method retrieves one or more BOM version records from the Bom_Ver table, as specified by the filter parameters. Passing no filter parameters will retrieve all BOM version records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal parentItemId As String, _
ByVal verId As String, _
ByVal verDate As Nullable(Of Date), _
ByVal verComments As String, _
ByVal preferredVer As Nullable(Of Boolean), _
ByVal disassembly As Nullable(Of Boolean), _
ByVal startEff As Nullable(Of Date), _
ByVal endEff As Nullable(Of Date), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal modId As String _
) As DataSet
'Usage
Dim parentItemId As String
Dim verId As String
Dim verDate As Nullable(Of Date)
Dim verComments As String
Dim preferredVer As Nullable(Of Boolean)
Dim disassembly As Nullable(Of Boolean)
Dim startEff As Nullable(Of Date)
Dim endEff As Nullable(Of Date)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim modId As String
Dim value As DataSet
value = BomVersion.GetAll(parentItemId, verId, verDate, verComments, preferredVer, disassembly, startEff, endEff, lastEditBy, lastEditAt, modId)
public static DataSet GetAll(
string parentItemId,
string verId,
Nullable<DateTime> verDate,
string verComments,
Nullable<bool> preferredVer,
Nullable<bool> disassembly,
Nullable<DateTime> startEff,
Nullable<DateTime> endEff,
string lastEditBy,
Nullable<DateTime> lastEditAt,
string modId
)
Parameters
- parentItemId
Optional filter parameter. Holds the ID of a parent item.
- verId
Optional filter parameter. Holds the ID of a BOM version record.
- verDate
Optional filter parameter. Holds the date when a BOM version was created or last modified.
- verComments
Optional filter parameter. Holds comments about a BOM version.
- preferredVer
Optional filter parameter. Holds a flag that specifies whether this is the preferred BOM version to make the parent item.
- disassembly
Optional filter parameter. Holds a flag that specifies whether the BOM determines what can be obtained from the main item.
- startEff
Optional filter parameter. Holds the date/time that indicates when a BOM version becomes effective, in UTC.
- endEff
Optional filter parameter. Holds the date/time that indicates when a BOM version becomes ineffective, in UTC.
- lastEditBy
Optional filter parameter. Holds the ID of a user who added or last updated a BOM version record.
- lastEditAt
Optional filter parameter. Holds the date/time when a BOM version record was added or last updated.
- modId
Optional filter parameter. Holds a modification ID that indicates when this record was created or last updated.
Return Value
Returns a DataSet that contains all the records in the Bom_Ver 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 |
|---|---|
|
parent_item_id |
A string that is the ID of an item being made. |
|
ver_id |
A string that is the ID of the BOM version. |
|
ver_date |
A string that is the date when the version was created or last updated. |
|
ver_comments |
A string that contains comments about a version. |
|
preferred_ver |
A Boolean that is a flag that specifies whether this is the preferred version to make the parent item. |
|
item_desc |
A string that is the description of the item. |
|
disassembly |
A Boolean that is a flag that specifies whether the BOM determines what can be obtained from the main item. |
|
start_eff |
A date/time that indicates when the BOM verion becomes effective, in UTC. |
|
end_eff |
A date/time that indicates when the BOM verion becomes ineffective, in UTC. |
|
last_edit_comment |
A string that contains comments about why the record was 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. |