MES Stateless API

GetAll Method (UtilState)

Save PDF

GetAll Method (UtilState)

Save PDF

Last UpdatedNov 06, 2025
6 minute read

The GetAll() method retrieves one or more utilization state records from the Util_State table, as specified by the filter parameters. Passing no filter parameters will retrieve all utilization state records from the table.

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal stateCd As Nullable(Of Integer), _
   ByVal stateDesc As String, _
   ByVal color As Nullable(Of Integer), _
   ByVal runtime As Nullable(Of Boolean), _
   ByVal downtime As Nullable(Of Boolean), _
   ByVal setuptime As Nullable(Of Boolean), _
   ByVal teardownTime As Nullable(Of Boolean), _
   ByVal fixedtime As Nullable(Of Boolean), _
   ByVal vartime As Nullable(Of Boolean), _
   ByVal failure As Nullable(Of Boolean), _
   ByVal defLabCode As String, _
   ByVal priority As Nullable(Of Integer), _
   ByVal newReasonCode As Nullable(Of Integer), _
   ByVal entityEnabled As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim stateCd As Nullable(Of Integer)
Dim stateDesc As String
Dim color As Nullable(Of Integer)
Dim runtime As Nullable(Of Boolean)
Dim downtime As Nullable(Of Boolean)
Dim setuptime As Nullable(Of Boolean)
Dim teardownTime As Nullable(Of Boolean)
Dim fixedtime As Nullable(Of Boolean)
Dim vartime As Nullable(Of Boolean)
Dim failure As Nullable(Of Boolean)
Dim defLabCode As String
Dim priority As Nullable(Of Integer)
Dim newReasonCode As Nullable(Of Integer)
Dim entityEnabled As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = UtilState.GetAll(stateCd, stateDesc, color, runtime, downtime, setuptime, teardownTime, fixedtime, vartime, failure, defLabCode, priority, newReasonCode, entityEnabled, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> stateCd,
   string stateDesc,
   Nullable<int> color,
   Nullable<bool> runtime,
   Nullable<bool> downtime,
   Nullable<bool> setuptime,
   Nullable<bool> teardownTime,
   Nullable<bool> fixedtime,
   Nullable<bool> vartime,
   Nullable<bool> failure,
   string defLabCode,
   Nullable<int> priority,
   Nullable<int> newReasonCode,
   Nullable<int> entityEnabled,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

stateCd: Optional filter parameter. Holds the code that identifies the utilization state to be retrieved.
stateDesc: Optional filter parameter. Holds the unique description for a state.
color: Optional filter parameter. Holds an integer that indicates a state's RGB background color in the user interface.
runtime: Optional filter parameter. Holds the default setting for a flag that indicates whether a utilization reason counts toward runtime events.
downtime: Optional filter parameter. Holds the default setting for a flag that indicates whether a utilization reason counts toward downtime events.
setuptime: Optional filter parameter. Holds the default setting for a flag that indicates whether a utilization reason counts toward setup time events.
teardownTime: Optional filter parameter. Holds the default setting for a flag that indicates whether a utilization reason counts toward teardown time events.
fixedtime: Optional filter parameter. Holds the default setting for a flag that indicates whether a utilization reason counts toward fixed time events.
vartime: Optional filter parameter. Holds the default setting for a flag that indicates whether a utilization reason counts toward variable time events.
failure: Optional filter parameter. Holds the default setting for a flag that indicates whether any time that the entity spends in the utilization reason code is considered failure time.
defLabCode: Optional filter parameter. Holds the default setting for a default labor code for utilization reasons when they are manually selected.
priority: Optional filter parameter. Holds the priority of a utilization, which is used to determine the reason for a line that has two or more bottleneck entities with differing reasons.
newReasonCode: Optional filter parameter. Holds the default setting for the utilization reason to which the reason should change when the maximum duration is exceeded.
entityEnabled: Optional filter parameter. Holds the default setting for the flag that, if true, indicates that an entity in this utilization reason is considered to be enabled.
lastEditBy: Optional filter parameter. Holds the user who added or last changed a utilization state record.
lastEditAt: Optional filter parameter. Holds a date/time when utilization state records were added or last modified.

Return Value

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

For the default utilization reason setting columns, a null indicates that a default value was not specified for that setting.

Column Name	Description
state_cd	An integer that is the code for the utilization state.
state_desc	A string that is the description of the utilization state.
color	An integer that indicates the RGB background color for this state description when displayed in the user interface.
runtime	This state's default utilization reason setting for a Boolean flag that indicates whether the utilization reason is used for runtime.
downtime	This state's default utilization reason setting for a Boolean flag that indicates whether the utilization reason is used for downtime.
setuptime	This state's default utilization reason setting for a Boolean flag that indicates whether the utilization reason is used for setup time.
teardowntime	This state's default utilization reason setting for a Boolean flag that indicates whether the utilization reason is used for teardown time.
fixedtime	This state's default utilization reason setting for a Boolean flag that indicates whether this utilization reason is used for fixed time.
vartime	This state's default utilization reason setting for a Boolean flag that indicates whether this utilization reason is used for variable time.
failure	This state's default utilization reason setting for a Boolean flag that indicates whether any time that the entity spends in the utilization reason code is considered failure time.
def_lab_cd	This state's default utilization reason setting for a string that is the default labor code for the utilization reason when it is manually selected.
priority	This state's default utilization reason setting for an integer that is the priority of the utilization reason, which is used to determine the reason for a line that has two or more bottleneck entities with differing reasons.
max_duration	An integer that is the maximum duration, in seconds, that the utilization reason is not considered to be in a severe condition or before the reason is changed to a new utilization reason code. If the New Reason Code parameter is not being used (that is, it is null) and the maximum duration is exceeded, the reason is marked as being Severe and the event is considered to be in a severe condition. The Severe flag is typically used with downtime events. If the New Reason Code parameter is being used and the maximum duration is exceeded, the utilization reason for the entity is changed to the new reason specified in the New Reason Code parameter.
new_reas_cd	This state's default utilization reason setting for an integer that specifies the utilization reason to which the reason should change when the maximum duration is exceeded.
standard_time	This state's default utilization reason setting for a double that specifies the standard amount of time, in minutes, that an entity is expected to be in the utilization reason.
min_time	This state's default utilization reason setting for a double that specifies the minimum amount of time, in minutes, that an entity is expected to be in the utilization reason.
max_time	This state's default utilization reason setting for a double that specifies the maximum amount of time, in minutes, that an entity is expected to be in the utilization reason.
ent_enabled	This state's default utilization reason setting for a Boolean flag that indicates whether an entity in this utilization reason is to be considered enabled.
category1	This state's default utilization reason entry for a string that is the content of the category1 field.
category2	This state's default utilization reason entry for a string that is the content of the category2 field.
category3	This state's default utilization reason entry for a string that is the content of the category3 field.
category4	This state's default utilization reason entry for a string that is the content of the category4 field.
last_edit_comment	A string that contains comments about why the record was added or changed.
last_edit_by	A string that is the ID of the user who added or last updated this record.
last_edit_at	A datetime that specifies when the record was added or last updated.

MES Stateless API