microsoft / microsoft/wiql-editor
Must Contain AND being treated as an OR
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 8
- Forks
- 4
- PR merge metrics
- No merged PRs in 30d
Description
This query should only show results for items linked to "X" but not "Y". However this does not seem to treat the AND correctly.
SELECT
[System.Id],
[System.Title],
[Microsoft.VSTS.Common.Severity],
[System.AreaPath],
[Custom.BugState],
[System.State],
[Custom.MilestoneIDList],
[System.CreatedDate],
[System.WorkItemType]
FROM workitemLinks
WHERE
(
[Source].[System.WorkItemType] = 'Bug'
AND NOT [Source].[System.Title] CONTAINS 'Squish'
AND [Source].[Custom.BugState] <> 'Closed'
AND NOT [Source].[System.Title] CONTAINS 'Integration'
)
AND (
[System.Links.LinkType] = 'System.LinkTypes.Related-Forward'
)
AND (
[Target].[System.WorkItemType] = 'Milestone'
AND [Target].[System.Title] CONTAINS 'X'
AND NOT [Target].[System.Title] CONTAINS 'Y'
)
ORDER BY [System.AreaPath],
[System.Id]
MODE (MustContain)
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing issue #43 with the supplied workitemLinks query and MODE (MustContain), focusing on the target title conditions for “X” and “Y”. Done means results include linked items containing “X” while excluding those containing “Y”, with the other shown filters still respected.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- typescript
- Domain
- backend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100