GetAll Method (BottleneckHistory)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal lineId As Nullable(Of Integer), _
ByVal entId As Nullable(Of Integer), _
ByVal startTime As Nullable(Of Date), _
ByVal endTime As Nullable(Of Date), _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim lineId As Nullable(Of Integer)
Dim entId As Nullable(Of Integer)
Dim startTime As Nullable(Of Date)
Dim endTime As Nullable(Of Date)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = BottleneckHistory.GetAll(lineId, entId, startTime, endTime, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> lineId,
Nullable<int> entId,
Nullable<DateTime> startTime,
Nullable<DateTime> endTime,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- lineId
- Optional filter parameter. Holds the the ID of a production line.
- entId
- Optional filter parameter. Holds the ID of an entity.
- startTime
- Optional filter parameter. Holds the start time of a bottleneck period.
- endTime
- Optional filter parameter. Holds the end time of a bottleneck period.
- lastEditBy
- Optional filter parameter. Holds the name of the user who added or last changed a bottleneck history record.
- lastEditAt
- Optional filter parameter. Holds a date/time of when a bottleneck history record was added or last changed.
Return Value
Returns a DataSet that contains all the records in the Bottleneck_History 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.
|
Column Name |
Description |
|---|---|
|
line_id |
An integer that is the ID of the line. |
|
line_name |
A string that is the name of the line. |
|
ent_id |
An integer that is the ID of the entity. |
|
ent_name |
A string that is the name of the entity. |
|
start_time_utc |
A datetime that is the starting time, in UTC, of the period to which a bottleneck history record applies. |
|
start_time_local |
A datetime that is the starting time, in the local time of the MES Middleware server, of the period to which a bottleneck history record applies. |
|
start_time |
A datetime that is the starting time, in the local time of the client who is requesting data from the server, of the period to which a bottleneck history record applies. |
|
end_time_utc |
A datetime that is the ending time, in UTC, of the period to which a bottleneck history record applies. If non-null, it should equal the start_time_* of the next bottleneck history record for this entity, unless the ability for the entity to run jobs was removed. |
|
end_time_local |
A datetime that is the ending time, in the local time of the MES Middleware server, of the period to which a bottleneck history record applies. If non-null, it should equal the start_time_* of the next bottleneck history record for this entity, unless the ability for the entity to run jobs was removed. |
|
end_time |
A datetime that is the ending time, in the local time of the client who is requesting data from the server, of the period to which a bottleneck history record applies. If non-null, it should equal the start_time_* of the next bottleneck history record for this entity, unless the ability for the entity to run jobs was removed. |
|
last_edit_comment |
A string that is a comment about why a bottleneck history record was added or changed. |
|
last_edit_by |
A string that is the user ID of a user who added or last edited a bottleneck history record. |
|
last_edit_at |
A datetime that identifies when a bottleneck history record was added or last modified. |