Search work items by text

Searches for work items that contain the given text in title, description, or other searchable fields. Supply the search phrase in the WITH clause. Use this for ad-hoc lookup when you know a keyword but not the work item ID. Results depend on the project and search indexing.

SELECT * FROM search_workitems_by_text WITH (SearchText='Text that I want to search for')