I am trying to export all work items, and related data, from an Azure DevOps project. I am using Work Item Query Language (WIQL) but have no luck.
SELECT * FROM... etc
Does not work. Any answers, thoughts, or suggestions?
I am trying to export all work items, and related data, from an Azure DevOps project. I am using Work Item Query Language (WIQL) but have no luck.
SELECT * FROM... etc
Does not work. Any answers, thoughts, or suggestions?
Copyright © 2021 Jogjafile Inc.
As Daniel mentioned, we cannot use wildcards in WIQL, it's not like SQL.
We have to specific either the friendly name or reference name of the fields to return the corresponding values. See Limits on WIQL length for details.
Actually, not all fields are required in general product scenarios, and the WIQL has the length limits. However, if you want to select all fields, then you can try to get all the available fields by calling Fields - List REST API, then specify them in your WIQL.