GetByFilter(String,String,String,Nullable<DateTime>,Nullable<DateTime>,Nullable<Int32>,String,Nullable<Int32>,String,String) Method
- Last UpdatedNov 06, 2025
- 4 minute read
The GetByFilter() method retrieves a set of QM specification records from the Qm_Spec table based on the input filters.
'Declaration
Public Overloads Shared Function GetByFilter( _
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 _
) As DataSet
'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 value As DataSet
value = QmSpec.GetByFilter(qmSpecName, qmSpecDesc, verId, startDate, endDate, entId, itemId, itemCategoryId, processId, operId)
public static DataSet GetByFilter(
string qmSpecName,
string qmSpecDesc,
string verId,
Nullable<DateTime> startDate,
Nullable<DateTime> endDate,
Nullable<int> entId,
string itemId,
Nullable<int> itemCategoryId,
string processId,
string operId
)
Parameters
- qmSpecName
- Optional. Contains the QM specification name.
- qmSpecDesc
- Optional. Contains the QM specification description.
- verId
- Optional. Contains the QM specification version.
- startDate
- Optional. Contains the QM specification start date.
- endDate
- Optional. Contains the QM specification end date.
- entId
- Optional. Contains the entity ID.
- itemId
- Optional. Contains the item ID.
- itemCategoryId
- Optional. Contains the item category ID.
- processId
- Optional. Contains the process ID.
- operId
- Optional. Contains the operation ID.
Return Value
Returns a DataSet that contains the DataRow of the specified QM specifications from the Qm_Spec table. If no matching record for the specified QM specification is found, an empty DataSet is returned.
The columns of the returned DataSet are described below.
| Column Name | Description |
|---|---|
| qm_spec_name | A string that is the name of the specification. |
| qm_spec_desc | A string that is the description of the specification. |
| edit_level | An integer that is the privilege level required to edit this record. |
| ver_id | A string that is the version of this specification. |
| start_eff_utc | A datetime value that is the UTC time when this version of the specification becomes effective. |
| start_eff_local | A datetime value that is the local date and time that corresponds to when this version of the specification becomes effective. The date and time are relative to the entity if ent_id is not null. Otherwise, it is relative to the middleware server. |
| start_eff | A datetime value that is the local date and time, relative to the client that is requesting the data from the server, that corresponds to when this version of the specification becomes effective. |
| end_eff_utc | A datetime value that is the UTC time when this version of the specification ceases to be effective. |
| end_eff_local | A datetime value that is the local time when this version of the specification ceases to be effective. The date and time are relative to the entity if ent_id is not null. Otherwise, it is relative to the middleware server. |
| end_eff | A datetime value that is the local time, relative to the client that is requesting the data from the server, when this version of the specification ceases to be effective. |
| ent_id | An integer that is the ID of the entity or entity class to which this specification applies. |
| ent_name | A string that is the name of the entity to which this specification applies. |
| item_id | A string that is the ID of the item to which this specification applies. |
| item_desc | A string that is the description of the item to which this specification applies. |
| item_display |
A string that is the value that indicates what format to use when identifying the item in the user interface. The format values are defined in the system attribute Item display (attr_id 210 in the System_Attr table). Possible values and their formats are: 0 = item_id 1 = item_desc 2 = item_id (item_desc) 3 = item_desc (item_id) |
| item_category_id | An integer that is the ID of the item category to which this specification applies. |
| item_category_name | A string that is the name of the item category to which this specification applies. |
| process_id | A string that is the ID of the process to which this specification applies. |
| oper_id | A string that is the ID of the operation to which this specification applies. |
| category_id | An integer that is the ID of the category to which this specification belongs. |
| plan_id | An integer that is the ID of the default sample plan for this specification. |
| num_pts_per_page | An integer that is the number of sample points per page for the SPC Chart. |
| display_seq | An integer that is the value for the display sequence of the specification (see Remarks). |
| spare1 | A string that is the value of the spare1 field, defined by language term 5157. |
| spare2 | A string that is the value of the spare2 field, defined by language term 5158. |
| spare3 | A string that is the value of the spare3 field, defined by language term 5159. |
| spare4 | A string that is the value of the spare4 field, defined by language term 5160. |
| last_edit_comment | A string that is the comments about why the record was added or updated. |
| last_edit_by | A string that is the ID of the user who added or last updated this record. |
| last_edit_at | A datetime value that indicates when the record was added or last updated. |
| qm_spec_id | An integer that is the QM specification ID. |
A QM specification's display_seq column value determines the order in which the specification record appears in the returned dataset. If two or more specifications in the returned dataset have the same order value (e.g., 2), then those specifications are ordered alphabetically within that order value's subgroup.