microsoft / microsoft/wiql-editor
Results not loading in Wiql Playground when selecting certain columns in query
Nobody has claimed this yet.
- Dominant language
- TypeScript
- Stars
- 8
- Forks
- 4
- PR merge metrics
- No merged PRs in 30d
Description
Describe the bug
We are getting a "Loading Workitems..." message with no results returned when we attempt to execute a query where we select the following columns:
- System.Id
- Custom.TargetCompletionDatee
Environment:
- Browser = Chrome and Firefox
- hosted (Azure Devops)
- Installed version: 2.1.69 (Latest)
Screenshots
To Reproduce
Steps to reproduce the behavior:
- Go to Wiql playground
- Enter the following query:
- SELECT
[System.Id],
[System.AssignedTo],
[System.State],
[System.Title],
[System.Tags],
[System.WorkItemType]
FROM workitems
WHERE
[System.TeamProject] = @project
AND [System.AreaPath] UNDER 'CSG-Wk-Mgmt\RMDM\Singleview'
AND [System.WorkItemType] = 'Bug'
AND [System.ChangedDate] > @today - 2
ORDER BY [System.ChangedDate] DESC
4. Click Run.
5. The "Loading workitems..." message appears and stays there. No results are returned.
6. Remove the [System.AssignedTo] line from the SELECT statement and click Run.
7. Results are now returned as expected
Expected behavior
Query should return results with any valid fields in the SELECT statement.
Additional context
Clicking on the "Open in queries" button to execute the query in ADO results in a successful query.
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 the query in the Wiql Playground using the SELECT fields in the issue, then compare its behavior with the successful Azure DevOps query. Trace the query execution and result-loading entry point to identify why a valid field leaves the interface on "Loading workitems..."; done means results load for queries containing that field.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure, typescript
- Domain
- frontend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 42/100