Retrieves a list of work items within a backlog level.

Table Specific Information

Select

The connector uses the Azure DevOps API to process WHERE clause conditions built with the following columns and operators:

• ProjectId supports the '=' operator.
• TeamId supports the '=' operator.
• BacklogId supports the '=' operator.

The rest of the filter is executed client-side in the connector.

NOTE: Specifying the TeamId and BacklogId can improve the performance when querying BacklogWorkItems.

For example:

    SELECT * FROM BacklogWorkItems WHERE ProjectId = '837ccd31-8159-4db3-b8ce-de0c36d2a0bf' AND TeamId = '27369296-c53e-4f21-9cac-1f0d62c87e40' AND BacklogId = 'Microsoft.EpicCategory'

Columns

Name	Type	References	Description
ProjectId	String		Id of the project in which the backlog was created.
TeamId	String	Teams.Id	Id of the team for which the backlog was created.
BacklogId	String	Backlogs.Id	Id of the backlog.
Rel	String		The type of link.
SourceId	Integer		Source work item ID.
SourceUrl	String		REST API URL of the source.
TargetId	Integer		Target work item ID.
TargetUrl	String		REST API URL of the target.