GetFilterCount Method
- Last UpdatedNov 06, 2025
- 2 minute read
The GetFilterCount() method retrieves a count of the active QM specifications that match the filter criteria, from the Qm_Spec table.
'Declaration
Public Shared Sub GetFilterCount( _
ByVal qmSpecName As String, _
ByVal qmSpecDesc As String, _
ByVal verId As String, _
ByVal startDate As Nullable(Of Date), _
ByVal endDate 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 activeSpecs As Nullable(Of Boolean), _
ByRef noOfRows As Integer _
)
'Usage
Dim qmSpecName As String
Dim qmSpecDesc As String
Dim verId As String
Dim startDate As Nullable(Of Date)
Dim endDate 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 activeSpecs As Nullable(Of Boolean)
Dim noOfRows As Integer
QmSpec.GetFilterCount(qmSpecName, qmSpecDesc, verId, startDate, endDate, entId, itemId, itemCategoryId, processId, operId, activeSpecs, noOfRows)
public static void GetFilterCount(
string qmSpecName,
string qmSpecDesc,
string verId,
Nullable<DateTime> startDate,
Nullable<DateTime> endDate,
Nullable<int> entId,
string itemId,
Nullable<int> itemCategoryId,
string processId,
string operId,
Nullable<bool> activeSpecs,
out int noOfRows
)
Parameters
- qmSpecName
- Optional. Contains the content for the QM specification name field.
- qmSpecDesc
- Optional. Contains the content for the QM specification description field.
- verId
- Optional. Contains the specification version.
- startDate
- Optional. Contains the QM specification start date.
- endDate
- Optional. Contains the QM specification end date.
- entId
- Optional. Contains the ID of the entity to which the specification applies.
- itemId
- Optional. Contains the ID of the item to which the specification applies.
- itemCategoryId
- Optional. Contains the ID of the item category to which the specification applies.
- processId
- Optional. Contains the ID of the process to which the specification applies.
- operId
- Optional. Contains the ID of the operation to which the specification applies.
- activeSpecs
- Optional. Indicates whether to include only active specifications (true) or both active and expired specifications (false).
- noOfRows
- Output. Contains the returned number of records that match the specified filters.
Return Value
The count of the active QM specifications that match the filter criteria.