GetAll Method (Attr)

• Visual Basic
• C#

'Declaration
 
Public Shared Function GetAll( _
   ByVal attrId As Nullable(Of Integer), _
   ByVal predefined As Nullable(Of Boolean), _
   ByVal dataType As Nullable(Of Integer), _
   ByVal attrDesc As String, _
   ByVal attrGrp As Nullable(Of Integer), _
   ByVal filtr As String, _
   ByVal entryType As Nullable(Of Integer), _
   ByVal visibleInQueue As Nullable(Of Boolean), _
   ByVal visibleInInv As Nullable(Of Boolean), _
   ByVal lastEditBy As String, _
   ByVal lastEditAt As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim attrId As Nullable(Of Integer)
Dim predefined As Nullable(Of Boolean)
Dim dataType As Nullable(Of Integer)
Dim attrDesc As String
Dim attrGrp As Nullable(Of Integer)
Dim filtr As String
Dim entryType As Nullable(Of Integer)
Dim visibleInQueue As Nullable(Of Boolean)
Dim visibleInInv As Nullable(Of Boolean)
Dim lastEditBy As String
Dim lastEditAt As Nullable(Of Date)
Dim value As DataSet
 
value = Attr.GetAll(attrId, predefined, dataType, attrDesc, attrGrp, filtr, entryType, visibleInQueue, visibleInInv, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> attrId,
   Nullable<bool> predefined,
   Nullable<int> dataType,
   string attrDesc,
   Nullable<int> attrGrp,
   string filtr,
   Nullable<int> entryType,
   Nullable<bool> visibleInQueue,
   Nullable<bool> visibleInInv,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

attrId

Optional filter parameter. Holds the ID of an attribute.

predefined

Optional filter parameter. Holds a flag that specifies whether the attribute is assigned to a set of predefined values.

dataType

Optional filter parameter. Holds an enumeration that indicates the data type of an attribute.

0 = string (less than 80 characters; the default)

1 = drop down from values defined in attr_set table

2 = integer

3 = currency

4 = color

5 = datetime

6 = floating point number

7 = percent

8 = check box

9 = non-editable

10 = time of day

11 = item reason (only if attr_grp = 3)

12 = long string (> 80 characters)

May be extended in future releases.

attrDesc

Optional filter parameter. Holds the description of an attribute.

attrGrp

Required. Holds the enumeration that identifies the group to which the attribute belongs.

1 = Items

2 = Entities

3 = Lots

4 = Item Classes

5 = Jobs

6 = WO

7 = Operations

8 = Processes

9 = Sublot

10 = Samples

11 = Results

12 = Lines

13 = Shifts

filtr

Optional filter parameter. Holds a string that identifies the filter for the situations to which an attribute applies. For example, for item reason attributes, this is a reason_grp_id.

entryType

Optional filter parameter. Holds an enumeration that indicates the type of entry to allow for an attribute.

0 = value only (the default)

1 = notes only

2 = value and notes

visibleInQueue

Optional filter parameter. Holds a flag that specifies whether this attribute is visible in the job queue.

visibleInInv

Optional filter parameter. Holds a flag that specifies whether this attribute is visible in the inventory.

lastEditBy

Optional filter parameter. Holds the ID of the user who added or last updated an attribute record.

lastEditAt

Optional filter parameter. Holds the date/time when an attribute record was added or last updated.

Return Value