GetChartTypeByFilter(Int32,Nullable<Int32>,String,Nullable<Int32>,String,String,String,String,String,String,String,String,String,Nullable<DateTime>,Nullable<DateTime>) Method

• Visual Basic
• C#

'Declaration
 
Public Overloads Shared Function GetChartTypeByFilter( _
   ByVal characteristicId As Integer, _
   ByVal entityId As Nullable(Of Integer), _
   ByVal item As String, _
   ByVal itemCategoryId As Nullable(Of Integer), _
   ByVal workOrderId As String, _
   ByVal operationId As String, _
   ByVal processId As String, _
   ByVal segmentRequirementId As String, _
   ByVal segmentResponseId As String, _
   ByVal spare1 As String, _
   ByVal spare2 As String, _
   ByVal spare3 As String, _
   ByVal spare4 As String, _
   ByVal startTime As Nullable(Of Date), _
   ByVal endTime As Nullable(Of Date) _
) As DataSet

'Usage
 
Dim characteristicId As Integer
Dim entityId As Nullable(Of Integer)
Dim item As String
Dim itemCategoryId As Nullable(Of Integer)
Dim workOrderId As String
Dim operationId As String
Dim processId As String
Dim segmentRequirementId As String
Dim segmentResponseId As String
Dim spare1 As String
Dim spare2 As String
Dim spare3 As String
Dim spare4 As String
Dim startTime As Nullable(Of Date)
Dim endTime As Nullable(Of Date)
Dim value As DataSet
 
value = Sample.GetChartTypeByFilter(characteristicId, entityId, item, itemCategoryId, workOrderId, operationId, processId, segmentRequirementId, segmentResponseId, spare1, spare2, spare3, spare4, startTime, endTime)

public static DataSet GetChartTypeByFilter( 
   int characteristicId,
   Nullable<int> entityId,
   string item,
   Nullable<int> itemCategoryId,
   string workOrderId,
   string operationId,
   string processId,
   string segmentRequirementId,
   string segmentResponseId,
   string spare1,
   string spare2,
   string spare3,
   string spare4,
   Nullable<DateTime> startTime,
   Nullable<DateTime> endTime
)

Parameters

characteristicId

Required. Holds the characteristic ID.

entityId

Optional filter parameter. Holds the ID of an entity at which a sample was pulled.

item

Optional filter parameter. Holds the item ID of a sample.

itemCategoryId

Optional filter parameter. Holds the ID of the item category. Any samples of items included in the category will match this filter.

workOrderId

Optional filter parameter. Holds the work order ID of a job for which a sample was pulled.

operationId

Optional filter parameter. Holds the ID of an operation that is associated with the characteristic. This parameter will filter on the oper_id column of the Sample table. This parameter is used in conjunction with the processId parameter. The combination of a process and an operation in that process is entered as a context property of a QM specification that is linked to the characteristic. For more information, see Remarks below.

processId

Optional filter parameter. Holds the ID of a process that is associated with the characteristic. This parameter is used in conjunction with the operationId parameter. The combination of a process and an operation in that process is entered as a context property of a QM specification that is linked to the characteristic. For more information, see Remarks below.

segmentRequirementId

Optional filter parameter. Holds the segment requirement ID of a sample.

segmentResponseId

Optional filter parameter. Holds the segment response ID of a sample.

spare1

Optional filter parameter. Holds the contents of the spare1 field for a sample.

spare2

Optional filter parameter. Holds the contents of the spare2 field for a sample.

spare3

Optional filter parameter. Holds the contents of the spare3 field for a sample.

spare4

Optional filter parameter. Holds the contents of the spare4 field for a sample.

startTime

Optional filter parameter. Holds the earliest date/time that a matching sample can have. The date/time are assumed to be in the local time of the calling client application. This is converted to UTC, which is then used to filter on the requested_time_utc column of the Sample table.

endTime

Optional filter parameter. Holds the latest date/time that a matching sample can have. The date/time are assumed to be in the local time of the calling client application. This is converted to UTC, which is then used to filter on the requested_time_utc column of the Sample table.

Return Value