The setting team.pinnedQueries in VSCode doesn't return the correct result

[louagej]

Hi,

When I query my workitems directly in Azure on New and Active work items, I get one workitem as result.

When I Use the pin in VSCode I receive all my workitems (16).

So it seems that the @Me filter is working, but the WHERE clause was dropped somewhere along the road.
This is the configuration in VSCode

"team.pinnedQueries": [
    {
      "account": "dev.azure.com/mycompany",
      "queryText": "SELECT * FROM WorkItems WHERE [System.AssignedTo] = @Me AND ([System.State] = 'New' OR [System.State] = 'Active')"
    }
]

[louagej]

For anyone struggling with the same issue, here's the solution:
Replace dev.azure.com/mycompany into global and add [System.TeamProject] = @project to only see the current work items from you project:

,
  "team.pinnedQueries": [
    {
      "account": "global",
      "queryText": "SELECT * FROM WorkItems WHERE [System.AssignedTo] = @Me AND [System.TeamProject] = @project AND ([System.State] = 'New' OR [System.State] = 'Active')"
    }
  ]