User Help > Displaying Items Meeting Specific Conditions > Query Filters
Query Filters
You determine what items are returned by a query by using filters. A filter limits the items returned by a query to those satisfying the conditions of the filter.
You can create a query using any combination of the following query filters:
Your ability to use certain query filters is determined by the permissions granted to you to view specific item types and fields. For further assistance, contact your administrator.
Filter Type
You can query for attachments that are linked to items with a specific field value or specific text.
You can search the database for items that have an attachment or that have an attachment of a specified size, date or time added, name, or MIME (Multipurpose Internet Mail Extensions) type.
Messages using the MIME standard can contain the following types of information: text messages in US-ASCII; character sets other than US-ASCII; multi-media, such as image, audio, and video messages; multiple objects in a single message; multi-font messages; messages of unlimited length; or binary files.
You can query on items that have a branch, or items that are branches of the original item. You can also create a query for finding a particular field of a branched item that has a specific value.
Change Packages
If you use change packages to identify files that are affected by an item, you can track and monitor items with change packages using the change package filter.
You can filter Windchill RV&S items based on change package types and their attributes.
Filtering on a change package attribute returns a list of all items that are associated with at least one change package that meets the specified criteria. There is currently no way to return only items where all of the associated change packages meet the specified criteria.
If you use the same Implementer Change Package filter more than once in a query, the query assumes that they are grouped through a logical AND relationship. For example, if you used two Member Name filters in a query, one specifying Order and the other Panel, the query searches for items with change packages that have at least one member name containing both Order and Panel. It does not query items with change packages that have at least one member name containing Order and at least one member name containing Panel.
You can create query filters to find content items used specifically in the document model. For example, you can create a query to search for segments, nodes, or for content defined as meaningful or non-meaningful content.
You can also create query filters for test management items. Test management items are items that have a specific test management role, as defined by your administrator.
You can search the database for items whose fields contain specific values.
Query by history searches only the information in the change record. You can query by the following history filters:
specific value in an item field
date and time an item was modified
user who modified an item
If you use more than one history filter to search for specific values in multiple fields, the query searches for items with a history where all the fields were changed at the same time (that is, as part of the same edit).
When you run a sub query based on queries that have at least one common history filter, some performance degradation occurs with large data sets. If the performance degradation is beyond an acceptable limit, you can fine-tune the SQL query by adding index as per your query design and the fields used in the query.
You can query on labels by label name, or use a combination of label names to search all items. For example, you can query on Defects containing one of two different labels.
You can query your database for items that are linked to other items. You can query for items with forward or backward relationships with other items linked through a specific relationship field. You can query for items that are linked to items with a specific field value or specific text.
You can search the database for items that satisfy the conditions of a sub-query.
Using a sub-query in your new query does not alter the sub-query in any way.
Test Results
You can query your database for items that have a test result, that have a test result with an attachment or related item, or for a specific field value in the test result.
Time Entries
You can query your database for items that contain time entries. A time entry records the duration of time spent working on an item in hours for a specific day, and, optionally, any relevant notes.
You can query on the database using the following walk functions that walk the relationships to traverse items:
The walk filter is available only for the users that have the CreateSharedAdmin permission.
The walk functions traverse the entire tree of documents. Consequently, the functions can return a large amount of results and increase the query time.
The walk functions can have performance issues when used with items that have multiple related items. The performance impact can be severe during concurrent execution of shared queries using the walk function. Such concurrent execution can occur indirectly when shared admin objects such as charts, reports, and dashboards use queries with the walk function.
Grouping Query Filters