GetAll Method (UtilReasCategorySet)
- Last UpdatedMar 17, 2026
- 2 minute read
The GetAll() method retrieves one or more utilization reason category set records from the Util_Reas_Category_Set table, as specified by the filter parameters. Passing no filter parameters will retrieve all utilization reason category set records from the table.
'Declaration
Public Shared Function GetAll( _
ByVal category As Nullable(Of Integer), _
ByVal possibleValue As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date), _
ByVal rowId As Nullable(Of Integer) _
) As DataSet
'Usage
Dim category As Nullable(Of Integer)
Dim possibleValue As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim rowId As Nullable(Of Integer)
Dim value As DataSet
value = UtilReasCategorySet.GetAll(category, possibleValue, lastEditBy, lastEditAt, rowId)
public static DataSet GetAll(
Nullable<int> category,
string possibleValue,
string lastEditBy,
Nullable<DateTime> lastEditAt,
Nullable<int> rowId
)
Parameters
- category
- Optional filter parameter. Holds the category of a utilization reason category possible value to be retrieved.
- possibleValue
- Optional filter parameter. Holds the possible value of a utilization reason category set to be retrieved.
- lastEditBy
- Optional filter parameter. Holds the user who added or last changed a utilization reason category set record.
- lastEditAt
- Optional filter parameter. Holds a date/time when utilization reason category set records were added or last modified.
- rowId
- Optional filter parameter. Holds the id of the utilization reason category set row in database.
Return Value
Returns a DataSet that contains all the records in the Util_Reas_Category_Set 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 |
|---|---|
| category | An integer that is the category to which the possible value applies. Available categories are 1 through 4. |
| possible_value | A string that is possible value of the category. |
| last_edit_comment | A string that is the comments about why the record was added or updated. |
| 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 is the date and time, in UTC, when the record was created or last updated. |
| row_id | An integer that is the unique row ID of the record. |