ostreifel / wiql-editor

Search work items with wiql queries.
https://marketplace.visualstudio.com/items?itemName=ottostreifel.wiql-editor
MIT License
32 stars 8 forks source link

Is possible to use Group by ? #44

Closed dmstole closed 4 years ago

dmstole commented 4 years ago

I try to use group by equal in SQL Language, like that:

SELECT
        COUNT(1) AS TOTAL,
        [System.Tags]
FROM workitems
WHERE [System.TeamProject] = @project
GROUP BY [System.Tags]
ORDER BY [System.ChangedDate] DESC
ostreifel commented 4 years ago

No, but for that example you could just call the tags api directly to get the list of all tags.