Analytics Archiver beating SQL Novice - advice please
Sean_Terry
Customer Advanced IT Monkey ✭✭✭
Appreciate its early days with the archiver. Just looking at what is possible whilst the global search doesn't search analytics.
I'm not entirely sure if this is possible yet. In some ways I prefer OData because it adds a search box for me but I wondered if there was a way to replicate this...
...Using SQL. This is the very basic SQL query I have
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [WorkItemId]
,[Title]
,[WorkItemId]
,[Status]
,[Priority]
,[AssignedUser]
,[CreatedByUser]
,[AffectedUser]
,[Category]
,[Tier]
,[LastModified]
,[ResolvedDate]
,[ClosedDate]
FROM [CiresonAnalytics].[dbo].[SM_WorkItem_ServiceRequest]
I assume that enable Chart Filtering might be what I'm after? If so, not entirely sure how I can change the query to either search a specific workitem id or tickets for a specific date span.
Basically looking to see if I can have dedicated page.
Best Answers
-
Brad_Zima
Member Advanced IT Monkey ✭✭✭
@Sean_Terry I think maybe this is what you are looking for:https://kb.cireson.com/article/user-guide-add-in-page-filter-widget/2620
Should give you selectable values to filter your queries.
0 -
Simon_Zeinhofer
Customer Ninja IT Monkey ✭✭✭✭
1
Answers
@Sean_Terry I think maybe this is what you are looking for:https://kb.cireson.com/article/user-guide-add-in-page-filter-widget/2620
Should give you selectable values to filter your queries.
@Sean_Terry I shared how we solved that meanwhile:
https://community.cireson.com/discussion/6526/search-in-the-archive-until-it-is-available-in-global-search#latest
mabye that helps :)