microsoft / wiql-to-odata-ado-extension

Translates a WIQL query to OData (for the Analytics extension) in Azure DevOps

WIQL to OData Azure DevOps Extension

Wiql to OData translates an Azure DevOps query into an OData query for use with Azure DevOps Analytics OData endpoints.

Features

• Convert 'flat list of work items' and 'work items and direct links' ADO queries to OData queries with the click of a button. These queries are url formatted and ready to be used in your apps with any http client.

Restrictions

• You must have Azure DevOps Analytics installed to your account.
• As with the Azure DevOps Analytics extension, this extension is currently in preview. It will not support some scenarios that OData or ADO Analytics currently doesn't support. For example...
  • Recursive (tree) Wiql queries are not supported.
  • Macros (such as @project, @me), are not supported. When possible, these values will be replaced with static values. @today is supported, but mathematical operations on @today such as @today - 1 are not supported, and will be replaced with a static value.
• The output query is a best guess, and may require some adjustment to perform exactly as required. Please heed the warnings listed below the query text.

Building the project

Just run:

npm run build:dev
npm run package:dev

This produces a .vsix file which can be uploaded to the Visual Studio Marketplace

You can also publish it to your own publisher by running:

npm run publish:dev

Reporting Security Issues

Security issues and bugs should be reported privately, via email, to the Microsoft Security Response Center (MSRC) at [email protected]. You should receive a response within 24 hours. If for some reason you do not, please follow up via email to ensure we received your original message. Further information, including the MSRC PGP key, can be found in the Security TechCenter.

Contributing

This project welcomes contributions and suggestions. Most contributions require you to agree to a Contributor License Agreement (CLA) declaring that you have the right to, and actually do, grant us the rights to use your contribution. For details, visit https://cla.microsoft.com.

When you submit a pull request, a CLA-bot will automatically determine whether you need to provide a CLA and decorate the PR appropriately (e.g., label, comment). Simply follow the instructions provided by the bot. You will only need to do this once across all repos using our CLA.

This project has adopted the Microsoft Open Source Code of Conduct. For more information see the Code of Conduct FAQ or contact [email protected] with any additional questions or comments.

wiql-to-odata-ado-extension's Issues

ADO theming does not work.

Need to upgrade to new ADO SDK and UI library.

This repo is missing important files

There are important files that Microsoft projects should all have that are not present in this repository. A pull request has been opened to add the missing file(s). When the pr is merged this issue will be closed automatically.

Microsoft teams can learn more about this effort and share feedback within the open source guidance available internally.

Merge this pull request

Question: do you plan for an on premise version?

Hi,
this extension only works in the cloud, any chance we get this for the server version of Azure DevOps ?
thanks,
Vincent