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 and number of days between the Start Date and Target Date.
• A single click on the work item displays the title.
• Zoom to fit the currently selected work item.
• Download the timeline in the xlsx or png format.
• Share the timeline via URL.
• Quick filtering using the "gmail" like filter syntax:
  • To filter items by title just type any text.
  • To filter by specific field use prefixes: title:, tag:, state:, priority:, assignedto:, targetdate:, startdate:, parent:, nodemane:.
  • You can use multiple filter clauses and join them with logical operators OR/AND.
• Visualisation of the Successor-Predecessor relations.

Quickfilter examples

• Work items which Title contains "text": text
• Work items which Title does not contain "text": -(text)
• Work items which State is set to "To Do": state:todo
• Work items which Start Date is set to the first of the february: startdate:2025-02-01
• Work items which Target Date is set to today: targetdate:@today
• Work items which parent's Title contains "text": parent:text
• Work items which Node Name contains "text": nodename:text
• Multiple condition with AND: state:todo AND tag:customer
• Multiple condition with OR: state:todo OR tag:customer

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.