Precise filters for Azure DevOps with WIQL

Tempo Team

Since the release of the Azure DevOps integration in October, many synced roadmaps have seamlessly kept both tools and teams better aligned. However, a consistent request has been raised… the ability to support WIQL filtering. Teams are looking for more finesse and control over the work items they pull in so their roadmaps represent a targeted set of necessary data.

Well, thanks to WIQL, you now can precisely define the specific work items you want to synchronize through context-based queries to ensure your roadmaps are focused and uncluttered! No longer will all your data pour into your roadmap, leaving you to be selective with what Fields to pull in or rely on Roadmunk filtering to trim down the data set. WIQL gives you the power and flexibility for a smarter, cleaner, and smoother synchronization.

If you are interested in using WIQL to filter your items, you are able to do so in a roadmap that’s currently integrated with Azure DevOps, or a brand new roadmap. Please note if you choose to edit an existing roadmap, items may be removed from your visualization based on the query parameters.

To being using WIQL in a new roadmap, just follow these steps:

Click the Integrations icon in the top right navigation. Enter valid Azure DevOps credentials and determine your sync settings
On the Filter Work Items screen, select the desired project, and then toggle the Configuration Mode from Basic to WIQL
Input your query into the Custom WIQL text field and click “Validate” to ensure that your query is correct
If "Everything looks good!" press “Next” and complete the setup by selecting the desired Fields and clicking “Let’s Go”

That’s it! Be sure to check out this Knowledge Base article for all the extra details and information. Happy filtering!

Strategic Roadmaps for Azure DevOps

Easily synchronize important work items and field data from Azure DevOps into a beautiful and strategic roadmap.

Enterprise solutions

Create a powerful, unified roadmap that connects to everything. Minimize risk and maximize ROI on your product investments, with Strategic Roadmaps

Continuous integration and delivery (CI/CD) explained

Learn the fundamentals and the importance of continuous integration and delivery (CI/CD), a mainstay of the DevOps development pipeline.

DevOps project management: Best practices and tools for success

Learn about DevOps project management and how this agile framework improves from team performance to product quality and customer satisfaction.

Using Exalate to sync between Tempo Timesheets Cloud and Jira

Exalate Modules add extensibility. Easily minimize the details of advanced system interactions and simplify the integration into synchronization.

Adding dashboard dynamic filters on Tempo accounts and teams

Learn how to use Rich Filters for Jira Dashboards to be able to quickly filter your dashboards by Tempo Accounts and Tempo Teams.

Account for where time goes with Tempo

Knowing the status of work is just as important as knowing when it will finish. See an aggregate of how long work takes for future estimation.

Jira best practices: Screen configuration and screen schemes

Create meaningful issue displays, speed up workflows, and increase efficiency by learning the best practices for Jira screens.

Strategic Roadmaps for Jira

Connect your high-level strategy with day-to-day planning by syncing your data seamlessly between Strategic Roadmaps and Jira.

Explore More Content

Structure and Gantt Charts

Gain a more complete project management solution, simplifying project reporting, improving collaboration, and ensuring projects stay on time and within budget.

Custom Charts for Confluence

Create and share all kinds of highly visual and customizable charts directly on your Confluence pages.

Time Tracker

Extend your Jira with prebuilt and highly configurable reports for straightforward time tracking.

Project Portfolio Management

Tempo Loop is the next evolution of PPM software. It continuously tracks work tied to the strategy it funded, so you don’t wait to find out about strategic drift in your next review. Know what every person and agent is working on and what it costs in real time.

Structure PPM and Strategic Roadmaps

For planning leaders looking to add a big-picture roadmap view to their structured Jira data, this integration is essential. Improve visibility to leadership, reduce reporting admin, and keep your team aligned.

Strategic portfolio management for business leaders

Tempo helps CIOs, CTOs, CPOs, and product executives turn big bets into bold results.

Capacity Planner

A powerful team resource management tool designed to optimize capacity planning and project management in Jira

Timesheets

Tempo’s intuitive automation and Jira-native design make it the most trusted time tracking tool for enterprise organization.

Agile at Scale

Adapt to changing business needs, rapidly adjust plans, and reallocate investment.

Idea Manager for Strategic Roadmaps

Never lose a brilliant idea again. Idea Manager for Strategic Roadmaps has built-in best practices to help.

Power BI Connector for ServiceNow

Seamlessly connect ServiceNow with Power BI, transforming complex enterprise data into actionable insights and driving smarter, data-informed decisions across the organization

Strategic Roadmaps (Roadmunk)

The roadmapping tool designed for high-performing teams delivering boardroom-ready strategic roadmaps.

Power BI Connector for Jira

Effortlessly bridge Jira with your preferred BI tool, unlocking unparalleled insights and enhancing decision-making

Strategic portfolio management for project and program managers

Tempo gives delivery leads, program managers, and scrum masters the clarity, structure, and tools they need to stay on track and keep leadership informed.

Gantt Charts for Structure PPM

Powered by Structure’s custom hierarchies, visualize your roadmap, project plans, timeline & dependencies within Jira Gantt charts

ITSM

Build and scale a custom ITSM solution at your own pace with Tempo's modular suite of integrated tools. Enhance Jira's capabilities and take control of your entire IT portfolio.

Structure PPM

Visualize all your Jira data & manage portfolios of projects in real-time.

Structure by Tempo

Jira Project Portfolio Management (PPM): Visualize data and manage projects within spreadsheet-like tables — in less than a minute

Professional Services Automation

Leverage Tempo to manage time, talent, and finances seamlessly within Jira.

Timesheets by Tempo

#1 Jira Time Tracking & AI Apps: Log Tempo Timesheets for Planning, Project Management & Billing. Plugin Office365, Google & Slack

Strategic portfolio management for agile leaders

Tempo helps transformation leads, agile program directors, and coaches scale agility with clarity, context, and coordination.

Timesheets and Capacity Planner

Seamlessly manage project timelines and resources while accurately tracking time spent on tasks. This integration enhances visibility, improves planning accuracy, and supports data-driven decision-making for better overall project outcomes.

Portfolio Manager and Jira

Portfolio Manager integrates seamlessly with Jira to give you predictive scheduling, real-time scenario modeling, and advanced resource management – ensuring you stay on track, no matter what challenges arise.

Custom Charts for Jira

See how work is progressing and where blockers are with the most flexible reporting app in Jira.

Financial Manager

Monitor projects and portfolios to get simple, clear, and real-time views of your costs, budgets, and profits that can be shared throughout your entire organization.

Workforce Intelligence

Capture human time and AI activity together in Jira so you can measure what your AI tools are truly contributing and costing.

BigQuery Connector for Jira

Integrate Jira with Google BigQuery to seamlessly export and sync data for advanced analytics and customized reporting

Capacity Planner

#1 Jira Resource Management App: Optimize team allocation, skillset utilization, capacity planning & project management

Portfolio Manager (LiquidPlanner)

Predictive scheduling and the ability to forecast project timelines and spot risks so you can meet deadlines with confidence.

Strategic portfolio management for PMO leaders

Tempo gives PMO directors and portfolio managers the tools to reduce delivery friction, align teams, and drive measurable outcomes.

AI Spend Management

Connect AI spend to the work it delivers. Attribute AI coding-tool costs to Jira epics and prove AI ROI, inside Jira with Tempo Workforce Intelligence.

Gantt Charts for Structure PPM

Visualize project plans and roadmaps with a Gantt chart extension for Jira

Timesheets and Structure

Combining Tempo Timesheets and Structure PPM provides a unified view of time tracking and project progress, enabling more accurate reporting and effective portfolio management. Simplify workflows, enhance collaboration, and ensure projects stay on time and within budget.