Edit Query

SQL Server-based software configuration management (SCM) tool/system

This page contains information on how to edit a query in the system.

Only the Administrators group can edit Public Queries globally. You must have Manage Public Queries permission to edit Public Queries in the project, but you can edit Private Queries without permission limitation.

To Edit Query

1. Right click the query that you wish to modify under the Public Queries or Private Queries node under the Queries or Team Project Queries node in Issue Tracking Explorer, select Edit Query, and the Edit Query page will appear, as seen in the following figure:

2. In the Query Condition Option tab, click the Add Condition icon on the top left to add or insert a new condition.

3. In the Display Column Options tab, you can edit the layout of the query result list.

4. In the Sorting Options tab, select a display field in Order by dropdown list, and select Descending or Ascending to sort the query result.

Window Items:

Query Condition Option

Add condition: Add or insert a new query condition. See Relation Among Field, Operator and Value.
Delete: Delete the selected condition.
And/Or: Decide whether the corresponding condition is an "And" condition or an "Or" condition. For "And" condition to be met, the corresponding condition and the previous condition must be met at the same time. For "Or" condition to be met, either condition could be true.
(: The open parenthesis inserted before the condition.
Field: Field related to the condition.
Operator: Operator related to the field.
Value: The value of the field.
): The close parenthesis inserted after the condition.

Display Columns:

Available Columns: List fields that are available to display in the query result.
Display Columns: List fields that are displayed in the query result.
Field: The name of the displayed field, such as ID and Title.
: Select a field from the Display Columns list, and click to remove the corresponding field from the table columns.
: Select a field from the Available Columns list, and click to add the field as a new column.
: Select a field from the Display Columns list, and click to move the field above.
: Select a field from the Display Columns list, and click to move the field below.
Width: Set the width of the selected field in the Available Columns list.

Sorting Option

Order by: The order of the query results. The first dropdown list contains all the fields that can be ordered in the system. The second dropdown list contains the types of the order: Descending and Ascending.

Finish editing the query and close the window.

Cancel

Cancel editing the query and close the window.

Note:

You can not modify the Query Condition Option tab when editing the default query My Watch.
If the field which was used on this page is deleted from the system, "????" will replace the deleted field.
If fields of Date or DateTime type are used in query conditions, the format of the field value should be "yyyy-mm-dd".