MES Stateless API

GetAll(Nullable<Int32>,String,Nullable<Int32>,String,Nullable<DateTime>) Method

Save PDF

GetAll(Nullable<Int32>,String,Nullable<Int32>,String,Nullable<DateTime>) Method

Save PDF

Last UpdatedNov 06, 2025
2 minute read

This is temporary until the MES Client is updated. The GetAll() method retrieves one or more utilization reason group records from the Util_Reas_Grp table, as specified by the filter parameters. Passing no filter parameters will retrieve all utilization reason group records from the table.

Syntax

'Declaration
 
Public Overloads Shared Function GetAll( _
   ByVal reasGrpId As Nullable(Of Integer), _
   ByVal reasGrpDesc As String, _
   ByVal parentReasGrpId As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim reasGrpId As Nullable(Of Integer)
Dim reasGrpDesc As String
Dim parentReasGrpId As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = UtilReasGrp.GetAll(reasGrpId, reasGrpDesc, parentReasGrpId, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> reasGrpId,
   string reasGrpDesc,
   Nullable<int> parentReasGrpId,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

reasGrpId: Optional filter parameter. Holds the ID of the utilization reason group that is being retrieved.
reasGrpDesc: Optional filter parameter. Holds the description of the utilization reason group that is being retrieved.
parentReasGrpId: Optional filter parameter. Holds the ID of a reason group's parent whose utilization reason groups are being retrieved
lastEditBy: Optional filter parameter. Holds the user who added or last changed a utilization reason group record.
lastEditAt: Optional filter parameter. Holds a date/time when utilization reason group records were added or last modified.

Return Value

Returns a DataSet that contains all the records in the Util_Reas_Grp 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
reas_grp_id	An integer that is the ID of the utilization group.
reas_grp_desc	A string that is the description of the reason group.
parent_reas_grp_id	An integer that is the ID of the parent reason group.
spare1	A string that is the content of the user-defined spare1 field.
spare2	A string that is the content of the user-defined spare2 field.
spare3	A string that is the content of the user-defined spare3 field.
spare4	A string that is the content of the user-defined spare4 field.
display_seq	An integer that is the order of display when displaying all the utilization reason groups in the user interface.
last_edit_comment	A string that contains comments about why the record was 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