Get work items by IDs (comma-separated)

Returns multiple work items in one request by passing a comma-separated list of IDs in the WITH clause. Useful when you have a fixed set of IDs (e.g. from a report or link) and want to load full details without running a WIQL query. The result set includes all columns for each work item.

SELECT * FROM get_workitems_by_ids WITH (ids='6444,5578,9467')