TFS WIQL Query with like condition

Question

I need to write a WIQL query on TFS 2018 with a like condition in the field IterationPath like this:

SELECT
        [System.Id],
        [System.WorkItemType],
        [System.Title],
        [System.State],
        [System.AreaPath],
        [System.IterationPath]
FROM workitems
WHERE
        [System.TeamProject] = @project
        and [System.IterationPath] LIKE '%MY ITERATION NAME%' 
ORDER BY [System.IterationPath] ASC

but I receive the error:

Expecting comparison operator. The error is caused by «LIKE».

How I have to write the query?

I tried also with the operator contains but it doesn't work – TeoVr81 Jun 19 '19 at 10:58 — TeoVr81, Jun 19 '19 at 10:58

score 3 · Accepted Answer · answered Jun 19 '19 at 11:06

3

The valid operators for Iteration Path are:

So you can't use Like (there is no Like operator in WIQL at all) or Contains.

The closest valid operator is Under, if all the iterations are under one parent you will get them all.

More info you can find here.

answered Jun 19 '19 at 11:06

Shayki Abramczyk

36,824
16
89
114

TFS WIQL Query with like condition

1 Answers1