microsoft / microsoft/wiql-editor

Results not loading in Wiql Playground when selecting certain columns in query

Open
#35 19 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

bug
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
image

To Reproduce
Steps to reproduce the behavior:

  1. Go to Wiql playground
  2. Enter the following query:
  3. 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

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.