GetAll Method (Cause)
- Last UpdatedNov 06, 2025
- 3 minute read
'Declaration
Public Shared Function GetAll( _
ByVal causeId As Nullable(Of Integer), _
ByVal causeDesc As String, _
ByVal causeGrpId As Nullable(Of Integer), _
ByVal spare1 As String, _
ByVal spare2 As String, _
ByVal spare3 As String, _
ByVal spare4 As String, _
ByVal lastEditBy As String, _
ByVal lastEditAt As Nullable(Of Date) _
) As DataSet
'Usage
Dim causeId As Nullable(Of Integer)
Dim causeDesc As String
Dim causeGrpId As Nullable(Of Integer)
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
value = Cause.GetAll(causeId, causeDesc, causeGrpId, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)
public static DataSet GetAll(
Nullable<int> causeId,
string causeDesc,
Nullable<int> causeGrpId,
string spare1,
string spare2,
string spare3,
string spare4,
string lastEditBy,
Nullable<DateTime> lastEditAt
)
Parameters
- causeId
- Optional filter parameter. Holds the ID of a cause to be retrieved.
- causeDesc
- Optional filter parameter. Holds a cause description.
- causeGrpId
- Optional filter parameter. Holds the ID of a cause group to which the causes being retrieved are linked.
- spare1
- Optional filter parameter. Holds the contents of a user-defined spare1 field.
- spare2
- Optional filter parameter. Holds the contents of a user-defined spare2 field.
- spare3
- Optional filter parameter. Holds the contents of a user-defined spare3 field.
- spare4
- Optional filter parameter. Holds the contents of a user-defined spare4 field.
- lastEditBy
- Optional filter parameter. Holds the user who added or last changed a cause record.
- lastEditAt
- Optional filter parameter. Holds a date/time when cause records were added or last modified.
Return Value
Returns a DataSet that contains all the records in the Cause 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 |
|---|---|
|
cause_id |
An integer that is the cause ID. |
|
cause_desc |
A string that is the description of the cause. |
|
cause_grp_id |
An integer that is the ID of the cause group of which the cause is a member. |
|
cause_grp_desc |
A string that is the description of the cause group of which the cause is a member, from the cause_grp.cause_grp_desc column linked to this cause. |
|
display_seq |
An integer that is the cause's display sequence number. The cause display sequence numbers are used to determine the order of causes when they are listed in the user interface. |
|
spare1 |
A string that is the contents of the user-defined spare1 field. |
|
spare2 |
A string that is the contents of the user-defined spare2 field. |
|
spare3 |
A string that is the contents of the user-defined spare3 field. |
|
spare4 |
A string that is the contents of the user-defined spare4 field. |
|
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. |