WIQL Playground executes query not supported by ADO Queries front end

[bart029]

Describe the bug
I created a query in the WIQL playground that returns results when run in the playground. When I click on the Open in queries button, an error is returned in ADO and no results are returned. WIQL playground should not support a query that results in an error in ADO.

Environment:

• Reproduceable in Chrome, Edge, and Firefox
• Hosted (Azure Devops)

Screenshots
Query executed in WIQL playground:

Error shown when clicking on Open in queries button:

To Reproduce
Steps to reproduce the behavior:

1. Enter the following query in the WIQL playground: SELECT
   [System.Id],
   [System.WorkItemType],
   [System.State],
   [System.Title]
   FROM workitems
   WHERE
   [System.TeamProject] = @project
   AND [System.AreaPath] UNDER 'CSG-Wk-Mgmt\COO\EDE\Tech Practices\K2'
   AND NOT (
   [System.WorkItemType] = 'Bug'
   AND [System.State] = 'New'
   )
2. Click the Run Button. THe query will return results
3. Click the Open in queries button. An error will be returned stating:
   Operation failed: Unexpected node: [System.WorkItemType] = 'Bug' and [System.State] = 'New'

Expected behavior
Either the WIQL playground should catch the error and give an informative message to the user within the playground OR the query should execute in ADO Queries in the same way it executes in the Wiql playground.

Additional context
I have isolated the issue causing this behavior to the "AND NOT" clause seen in line 10 combined with the "=" operator in line 11 and 12 of my attached query. If it is replaced with "AND" and "<>" the error disappears.

[AminTi]

Hi, I will test it and get back to you as soon as possible

[bart029]

Any updates??

[bart029]

Still looking for an update to this issue.

[AminTi]

We are currently working on many extensions, and we've added your issue to our backlog. We appreciate your patience and understanding as we strive to address it as soon as possible.