Query regarding search archiver in the portal
I'm know things are on the roadmap to look at searching the archiver via the portal, but in the meantime, I wondered if there was another way, so I was playing around with the query below to list items in a table.
SELECT TOP (1000) [WorkItemId] ,[Title] ,[Created] ,[CreatedByUser] AS 'Creator' ,[Status] ,[Priority] ,[Risk] ,[AssignedUser] ,[CreatedByUser] ,[ActualStartDate] ,[ActualEndDate] FROM [CiresonAnalyticsAcct].[dbo].[SM_WorkItem_Change] WHERE Status = 'Closed'
I've looked at the @createdFilter but not sure it will help, and I have been looking at tokens to try and understand them better.
I guess the perfect solution is if it could generate a search box (similar to OData) where we could put the ID in, and it searches the 1000 items and beyond. Is there any way to achieve this or is this pointing at a feature request?