Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Save more on your purchases now! discount-offer-chevron-icon
Savings automatically calculated. No voucher code required.
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Reporting in TFS

You're reading from   Reporting in TFS Create and customize reports in Team Foundation Server using Excel and SQL Server Reporting Services

Arrow left icon
Product type Paperback
Published in Apr 2015
Publisher
ISBN-13 9781782176138
Length 164 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Dipti Chhatrapati Dipti Chhatrapati
Author Profile Icon Dipti Chhatrapati
Dipti Chhatrapati
Arrow right icon
View More author details
Toc

Flat queries

A flat query list of work items is used when you want to perform the following tasks:

  • Finding a work item with an unknown ID
  • Checking the status or other columns of work items
  • Finding work items that you want to link to other work items
  • Exporting work items to Microsoft Office, Microsoft Excel, and Office Project for bulk updates to column fields
  • Generating a report about a set of work items

As a general practice, to easily find work items, a team member can create Shared Queries, which are predefined queries shared across the team. They can be created, modified, and saved as a new query too.

The following steps demonstrate how to open a flat query list and create a new query list:

  1. In the team project web portal, expand Shared Query List located on the left-hand side and click on the My Tasks query, as shown in the following screenshot:
    Flat queries
  2. The resulting work items generated by the My Tasks query will be shown in the Work item pane, as shown in the following screenshot:
    Flat queries
  3. As there are now...
You have been reading a chapter from
Reporting in TFS
Published in: Apr 2015
Publisher:
ISBN-13: 9781782176138
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at €18.99/month. Cancel anytime