Add, Remove, Reorder, and Sort Columns (Team Explorer Everywhere)

  • Article

You can find specific work items and related information more easily by adding columns to the results list for a particular query. You can then highlight the most useful data if you sort the list by one or more columns. The default display columns are ID, Work Item Type, Title, Assigned To, and State. These columns appear in the query results for all types of work items.

For information about how to navigate within the query editor or query view using keyboard shortcuts, see Keyboard Shortcuts for the Query Editor and Query Results View (TEE).

Required Permissions

To perform these procedures, you must be a member of the Readers group, or your View work items in this node permission must be set to Allow. For more information, see the following topic on the Microsoft Web site: Team Foundation Server Permissions.

To add, remove, and reorder columns

  1. Open a work item query.

    For more information, see Finding Bugs, Tasks, and Other Work Items (Team Explorer Everywhere).

  2. On the toolbar, click Column Options.

    You can also right-click in the query window and then click Column Options.

  3. Click the Fields tab if it is not already active.

  4. Perform one or more of the following steps:

    • In the Available columns list, click a column that you want to add, and then click Add selected columns (arrow that points to the right).

    • In the Selected columns list, click a column that you want to remove, and then click Remove selected columns (arrow that points to the left).

    • In the Selected columns list, click a column that you want to appear in a different location in the results list, and then click Move up or Move down (arrow that points up or arrow that points down).

      If you click Move up, the column will appear on the left of the column that precedes it. If you click Move down, the column will appear on the right side of the column that precedes it.

  5. Click OK.

To sort a list of results by a single column

  1. Open a work item query.

    For more information, see Finding Bugs, Tasks, and Other Work Items (Team Explorer Everywhere).

  2. In the results list, click the heading of the column by which you want to sort.

    You can click the heading again to toggle the sorting order between ascending and descending.

To sort a list of results by multiple columns

  1. Open a work item query.

    For more information, see Finding Bugs, Tasks, and Other Work Items (Team Explorer Everywhere).

  2. On the toolbar, click Column Options.

    You can also right-click in the query window and then click Column Options.

  3. Click the Sorting tab if it is not already active.

  4. Perform one or more of the following steps:

    • In the Available columns list, click a column that you want to add, and then click Add selected columns (arrow that points to the right).

    • In the Selected columns list, click a column that you want to remove, and then click Remove selected columns (arrow that points to the left).

    • In the Selected columns list, click a column that you want to appear in a different location in the results list, and then click Move up or Move down (arrow that points up or arrow that points down).

      If you click Move up, the column will appear on the left of the column that precedes it. If you click Move down, the column will appear on the right side of the column that precedes it.

  5. Click OK.

See Also

Tasks

List Work Items (Default Flat List) (Team Explorer Everywhere)

Other Resources

Finding Bugs, Tasks, and Other Work Items (Team Explorer Everywhere)