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

• Visual Basic
• C#

'Declaration
 
Public Overloads Shared Function GetChartDataByFilter( _
   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), _
   ByVal numberOfPoints As Nullable(Of Integer), _
   ByVal chartType As Integer, _
   ByVal lastCreatedAtUtc As 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 numberOfPoints As Nullable(Of Integer)
Dim chartType As Integer
Dim lastCreatedAtUtc As Date
Dim value As DataSet
 
value = Sample.GetChartDataByFilter(characteristicId, entityId, item, itemCategoryId, workOrderId, operationId, processId, segmentRequirementId, segmentResponseId, spare1, spare2, spare3, spare4, startTime, endTime, numberOfPoints, chartType, lastCreatedAtUtc)

public static DataSet GetChartDataByFilter( 
   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,
   Nullable<int> numberOfPoints,
   int chartType,
   DateTime lastCreatedAtUtc
)

Parameters

characteristicId

Required. Holds the characteristic ID.

entityId

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

item

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

itemCategoryId

Optional filter parameter. Holds the ID of an 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.

numberOfPoints

Optional filter parameters. Specifies the maximum number of data points that will be returned for the chart. If null, all data points are included in the chart.

chartType

Required. An enumeration that indicates the chart type.

2 = Xbar + Range

3 = Xbar + Sigma

5 = IX + IR

7 = MA + Range

8 = MA + Sigma

16 = p

17 = np

18 = u

19 = c

20 = DPMO

lastCreatedAtUtc

Required. Specifies the date and time in UTC to filter the chart data by only samples that have had results added at that date and time or later. This parameter will filter on the created_at_utc column of the Result table.

Return Value