How to get @mentioned Items using WIQL - DevOps Query

Question

I want to get all workitem/names where I have been mentioned using @mention
Am using WIQL query (not REST API)

Please suggest.

Thanks,
Soumen Dey

Answer 1

Try the below:

SELECT
    [System.Id],
    [System.WorkItemType],
    [System.Title],
    [System.AssignedTo],
    [System.State],
    [System.AreaPath],
    [System.CommentCount]
FROM workitems
WHERE
    [System.TeamProject] = @project
    AND [System.Id] IN (@recentMentions)
    AND NOT [System.State] IN ('Closed', 'Inactive', 'Completed')
ORDER BY [System.ChangedDate] DESC