MES Stateless API

GetAll Method (UtilReasLink)

Save PDF

GetAll Method (UtilReasLink)

Save PDF

Last UpdatedNov 06, 2025
2 minute read

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

Syntax

'Declaration
 
Public Shared Function GetAll( _
   ByVal entId As Nullable(Of Integer), _
   ByVal rawReasCd As String, _
   ByVal reasCd As Nullable(Of Integer), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim entId As Nullable(Of Integer)
Dim rawReasCd As String
Dim reasCd As Nullable(Of Integer)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = UtilReasLink.GetAll(entId, rawReasCd, reasCd, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> entId,
   string rawReasCd,
   Nullable<int> reasCd,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

entId: Optional filter parameter. Holds the ID of an entity whose utilization reason links are being retrieved.
rawReasCd: Optional filter parameter. Holds the code of the raw reason from I/O whose utilization reason links are being retrieved.
reasCd: Optional filter parameter. Holds the possible final reason code whose utilization reason links are being retrieved.
lastEditBy: Optional filter parameter. Holds the user who added or last changed a utilization reason link 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_Link 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
ent_id	An integer that is the entity linked to this utilization reason.
raw_reas_cd	A string that is the raw reason code linked to this entity and reason.
reas_cd	An integer that is the reason code linked to this entity and raw reason code.
ent_name	A string that is the entity name, from the ent.ent_name column linked to this entity ID for this utilization reason is returned.
reas_desc	A string that is the description of the reason, from the util_reas.reas_desc column linked to this reason.
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.

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

MES Stateless API