About the extension

Query Gantt is an extension for the Azure DevOps, which enables you to view the result of the selected query in the form of a Gantt chart using the vis-timeline and export it to the excel file using the xlsx-populate parser/generator.

Features

• Zoom in/out the timeline.
• View tags, priority, state, assigned to, dates, number of days between the Start Date and Target Date, iteration and area path, team project, parent work item, effort, remaining work, completed work.
• A single click on the work item displays the work item details including description.
• Download the timeline in the xlsx or png format.
• Share the timeline via URL (user needs to copy the URL address in the browser address bar).
• Filtering by Id, Title, Period, Assigned To, State, Priority, Tags, Area and Parent work item.
• Visualisation of the Successor-Predecessor relations.

Setup

After installing the extension from the Marketplace, you need to enable it in the Manage features section. In order to do so, follow the instructions here.

How does it work

Query Gantt can be used for any type of the query, but only those work items which have the Start Date (Microsoft.VSTS.Scheduling.StartDate) and Target Date (Microsoft.VSTS.Scheduling.TargetDate) set will be visualised on the timeline.

Which work items have the Start Date and the Target Date depends on the process you are using in your project. However you can add these fields to your work items following the instructions here.

If the work item has set up both Start Date and Target Date it will be rendered as a bar, if the work item has set up only the Target Date it will be rendered as a marker on the timeline.

Support

Email us at info.emait@gmail.com for any help on this extension or if you would like to request a new feature.