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

• Visual Basic
• C#

'Declaration
 
Public Overloads Shared Function GetChartDataByFilter( _
   ByVal characteristicName As String, _
   ByVal siteName As String, _
   ByVal entityName As String, _
   ByVal item As String, _
   ByVal itemCategoryName As String, _
   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 _
) As DataSet

'Usage
 
Dim characteristicName As String
Dim siteName As String
Dim entityName As String
Dim item As String
Dim itemCategoryName As String
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 value As DataSet
 
value = Sample.GetChartDataByFilter(characteristicName, siteName, entityName, item, itemCategoryName, workOrderId, operationId, processId, segmentRequirementId, segmentResponseId, spare1, spare2, spare3, spare4, startTime, endTime, numberOfPoints, chartType)

public static DataSet GetChartDataByFilter( 
   string characteristicName,
   string siteName,
   string entityName,
   string item,
   string itemCategoryName,
   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
)

Parameters

characteristicName

Required. Holds the name of the characteristic being charted.

siteName

Optional filter parameter. Holds the name of the site to which the supplied entity belongs. Must be null if sites are not being used.

entityName

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

item

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

itemCategoryName

Optional filter parameter. Holds the name 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

Return Value