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.

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.

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.

A practical guide to DORA metrics

DORA metrics help DevOps teams measure speed and quality and achieve consistent results. Learn how to gauge these KPIs and boost performance.

Mastering Jira filters: Create, share, and manage for better project insights

Learn to create, share, and manage Jira filters to improve workflow, generate insights, and provide transparency to project teams and stakeholders.

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.

Exploring Jira functionality: Making JQL work for you

Streamline report generation by learning to use JQL to conduct advanced searches within Jira. Then, boost productivity by saving and reusing queries.

Jira best practices: Configuring built-in fields in Jira

Jira's customizable Built-in Fields offer an easy way to organize and filter projects across your organization

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

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.

Structure PPM

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

Gantt Charts for Structure PPM

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

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

Time Tracker

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

Agile at Scale

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

Gantt Charts for Structure PPM

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

Capacity Planner

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

Workforce Intelligence

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

Professional Services Automation

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

Timesheets

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

Strategic Roadmaps (Roadmunk)

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

BigQuery Connector for Jira

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

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.

Capacity Planner

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

Team working together at board with sticky notes

Power BI Connector for monday.com

Get powerful data export capabilities and connect monday.com to Power BI effortlessly

Power BI Connector for Jira

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

Custom Charts for Confluence

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

Tableau Connector for Jira

Effortlessly bridge Jira with Tableau, unlocking unparalleled insights and enhancing decision-making

Strategic Portfolio Management

Modern modular PPM solutions that scale with your business. Align your teams with the integrated platform that bridges the gap between strategy and execution.

Financial Manager

Project financial management for Jira & Timesheets. Monitor project costs, expenses, revenue, billing & budgets. Track Capex/Opex

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.

Portfolio Manager (LiquidPlanner)

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

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.

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.

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.

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.