GetAll Method (QmSpec)

• Visual Basic
• C#

'Declaration
 
Public Shared Function GetAll( _
   ByVal qmSpecId As Nullable(Of Integer), _
   ByVal qmSpecName As String, _
   ByVal qmSpecDesc As String, _
   ByVal editLevel As Nullable(Of Integer), _
   ByVal verId As String, _
   ByVal startEffUtc As Nullable(Of Date), _
   ByVal startEffLocal As Nullable(Of Date), _
   ByVal endEffUtc As Nullable(Of Date), _
   ByVal endEffLocal As Nullable(Of Date), _
   ByVal entId As Nullable(Of Integer), _
   ByVal itemId As String, _
   ByVal itemCategoryId As Nullable(Of Integer), _
   ByVal processId As String, _
   ByVal operId As String, _
   ByVal categoryId As Nullable(Of Integer), _
   ByVal planId As Nullable(Of Integer), _
   ByVal numberPointsPerPage 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 qmSpecId As Nullable(Of Integer)
Dim qmSpecName As String
Dim qmSpecDesc As String
Dim editLevel As Nullable(Of Integer)
Dim verId As String
Dim startEffUtc As Nullable(Of Date)
Dim startEffLocal As Nullable(Of Date)
Dim endEffUtc As Nullable(Of Date)
Dim endEffLocal As Nullable(Of Date)
Dim entId As Nullable(Of Integer)
Dim itemId As String
Dim itemCategoryId As Nullable(Of Integer)
Dim processId As String
Dim operId As String
Dim categoryId As Nullable(Of Integer)
Dim planId As Nullable(Of Integer)
Dim numberPointsPerPage 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 = QmSpec.GetAll(qmSpecId, qmSpecName, qmSpecDesc, editLevel, verId, startEffUtc, startEffLocal, endEffUtc, endEffLocal, entId, itemId, itemCategoryId, processId, operId, categoryId, planId, numberPointsPerPage, spare1, spare2, spare3, spare4, lastEditBy, lastEditAt)

public static DataSet GetAll( 
   Nullable<int> qmSpecId,
   string qmSpecName,
   string qmSpecDesc,
   Nullable<int> editLevel,
   string verId,
   Nullable<DateTime> startEffUtc,
   Nullable<DateTime> startEffLocal,
   Nullable<DateTime> endEffUtc,
   Nullable<DateTime> endEffLocal,
   Nullable<int> entId,
   string itemId,
   Nullable<int> itemCategoryId,
   string processId,
   string operId,
   Nullable<int> categoryId,
   Nullable<int> planId,
   Nullable<int> numberPointsPerPage,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   string lastEditBy,
   Nullable<DateTime> lastEditAt
)

Parameters

qmSpecId

Optional. An integer value to filter the dataset by specification identifier.

qmSpecName

Optional. A string value to filter the dataset by the name of the specification.

qmSpecDesc

Optional. A string value to filter the dataset by the description of the specification.

editLevel

Optional. An integer value to filter the dataset by the privilege level required to edit this record. Default = 1.

verId

Optional. A string value to filter the dataset by the version of this specification.

startEffUtc

Optional. A datetime value to filter the dataset by the UTC time when a version of a specification becomes effective. The default is the current date and time.

startEffLocal

Optional. A datetime value to filter the dataset by the local time when a version of a specification becomes effective. The default is the current date and time. The date and time are relative to the entity if ent_id is not null. Otherwise, it is relative to the middleware server.

endEffUtc

Optional. A datetime value to filter the dataset by the UTC time when this version of this specification ceases to be effective. The end_eff_utc is null when there is a Qm_Spec record with the same name but a later start_eff date (i.e., when this one is superseded).

endEffLocal

Optional. A datetime value to filter the dataset by the local time when this version of this specification ceases to be effective. The end_eff_local is null when there is a Qm_Spec record with the same name but a later start_eff_local date (i.e., when this one is superseded). The date and time are relative to the entity if ent_id is not null. Otherwise, it is relative to the middleware server.

entId

Optional. An integer value to filter the dataset by the entity or the entity class to which this specification applies.

itemId

Optional. A string value to filter the dataset by the item to which this specification applies. If not null, item_category_id must be null.

itemCategoryId

Optional. A string value to filter the dataset by the item category to which this specification applies. If not null, item_id must be null.

processId

Optional. A string value to filter the dataset by the process to which this specification applies. Either both must be null or both non-null.

operId

Optional. A string value to filter the dataset by the operation to which this specification applies. Either both must be null or both non-null.

categoryId

Optional. An integer value to filter the dataset by the category to which this specification belongs.

planId

Optional. An integer value to filter the dataset by the default sample plan for this specification.

numberPointsPerPage

Optional. An integer value to filter the dataset by the number of sample per page for SPC Chart.

spare1

Optional filter parameter. Holds a string value to filter the dataset by a value defined by language term 5157.

spare2

Optional filter parameter. Holds a string value to filter the dataset by a value defined by language term 5157.

spare3

Optional filter parameter. Holds a string value to filter the dataset by a value defined by language term 5157.

spare4

Optional filter parameter. Holds a string value to filter the dataset by a value defined by language term 5157.

lastEditBy

Optional filter parameter. Holds a string value to filter the dataset by ID of the user who created or last modified this record.

lastEditAt

Optional filter parameter. Holds a datetime value to filter the dataset by the time that the row was last edited to retrieve information about.

Return Value