Query criteria table

You can use the following query criteria options to build queries and produce the following actions in query output.
Criteria
Action
Assigned
Finds all tasks assigned after, during, or before a specified date, or for a range of dates.
Assigned To
Finds all tasks assigned to a specific user.
Auto Update
Finds all project groupings that are set to automatically update the baseline and tasks when updating a project.
Baseline and Tasks Updated
Finds all project groupings that are set to automatically update the baseline and tasks when updating a project (true). Finds all project groupings that are set not to automatically update the baseline and tasks when updating a project (false).
Completed
Finds all tasks completed after, during, or before a specified date, or for a range of dates.
Completed By
Finds all tasks completed by a specific date.
Completed in Database
Finds all objects completed in a specific database.
Created
Finds all objects created after, during, or before a specified date, or for a range of dates.
Created in Database
Finds all objects created in a specific database.
Custom
Finds all objects with the criteria you have specified.
Estimated to be Completed
Finds all tasks estimated to be completed by a specific date, or for a range of dates.
For Change Request
Finds all tasks associated with a specific change request.
For Component
Finds all releases with a specific component name.
For Platform
Finds all objects for a specific platform.
For Release
Finds all objects for a specific release.
In a Process
Finds the process rules in a process (true) or not in a process (false).
In State
Finds all objects in the requested state. This box is not editable.
Is Product
Finds files defined as products.
Local to Database
Finds the object or project with the database ID of the database in which the object was either initialized or created.
Of Type
Finds all files of a specific type value.
Modifiable By
Finds all folders and folder templates that can be modified by no one, owner, build manager, or everyone.
Modifiable in Database
Finds all objects that can be modified in a specific database.
Modified
Finds all objects modified after, during, or before a specified date.
That are Active
Finds all releases that are active (true) or inactive (false).
That Finds Baseline Projects Using
Finds baseline projects that use the specified process rule criteria.
Using
Finds the object that you are trying to find a relationship with. The types of objects that display for a specified object depend on the specified object.
Using a Query
Finds folders or folder templates that use a query (true) or do not use a query (false).
With Actual Effort
Finds all tasks that state a specific actual effort time.
With Build
Finds all baselines that use the specified build.
With Description
Finds a task, folder, or folder template with a specific description. Is case-sensitive.
With Estimated Effort
Finds all tasks that state a specific estimated effort time.
With ID
Finds a task or folder with a specific identification. Is case-sensitive.
With Instance
Finds all objects with a specific instance value.
With Maintained Work Area
Finds all projects that do or do not maintain a work area.
With Name
Finds all objects with a specific name.
With Owner
Finds all objects with a specific owner.
With Parallel Restrictions
Finds all releases with the specified parallel restrictions setting.
With Priority
Finds all tasks with a specific priority value.
With Purpose
Finds all projects, project groupings, process rules, or baselines with a specific purpose value.
With Relative Work Area
Finds all projects with relative (true) or absolute (false) work areas
With Subsystem
Finds all tasks with a specific subsystem value.
With Version
Finds all objects with a specific version.

Feedback