Azure DevOps Historic Wiql AsOf Query

This extension shows the top level work items count for a query.... looking back in time.

This extension adds the 'History' tab to the Queries page.

To learn more about Azure DevOps Queries, please visit https://docs.microsoft.com/en-us/azure/devops/boards/queries/about-managed-queries.

To learn more about the Azure DevOps Wiql ASOF syntax, please visit https://docs.microsoft.com/en-us/azure/devops/boards/queries/wiql-syntax?view=azure-devops#historical-queries-asof.

Supported query types:

• Flat list of work items
• Work items and direct links (chart shows the count of top level work items)

Unsupported query types:

• Tree of work items (Error: "The specified query can not be executed using recursive tree query.") ORDER BY and ASOF aren't compatible with tree queries.

Dashboard usage

• use the widget 'Embedded webpage'
• use the url from the Historic Queries tab (example: https://dev.azure.com/<organization>/<project>/_queries/FlorianEckert.historic-query.overview/<query_id>/?fullScreen=true) with the extra parameter 'fullScreen=true'

• Any feedback is welcome (support@expectingsnow.com).
• User settings are stored on a per user per project basis within Azure DevOps Data storage.
• Azure ApplicationInsights Telemetry is used to optimize this service.