Saved search - display the Created Date column
Eugene_Rack
Customer Adept IT Monkey ✭✭
When selecting My Calls, My work, Active work the results have a created date column. However if you create your own search and save it, there is not Created Date column. Is there a way to have this enabled?
0
Best Answer
-
carrie_medine
Member Advanced IT Monkey ✭✭✭
Hello not currently with saved search however if you have a Dashboards license you may create your own query using the SQL Table Widget detailed here: https://support.cireson.com/KnowledgeBase/View/1291#/
Here is a sample sql statement to return Incidents with the Created Date:
SELECT wi.WorkItemId as [Id], wi.Title, wi.Created, ds.DisplayString Tier, wi.AssignedUser
FROM [WorkItem] wi
LEFT JOIN [Enumeration] enum ON enum.EnumerationID = wi.TierId
INNER JOIN [DisplayString] ds ON ds.ElementID=enum.EnumerationID
WHERE wi.ClassId = 'A604B942-4C7B-2FB2-28DC-61DC6F465C68'
AND wi.StatusId NOT IN('2b8830b6-59f0-f574-9c2a-f4b4682f1681','bd0ae7c4-3315-2eb3-7933-82dfc482dbaf')
AND ds.LocaleID='ENU'
8
Answers
Here is a sample sql statement to return Incidents with the Created Date:
SELECT wi.WorkItemId as [Id], wi.Title, wi.Created, ds.DisplayString Tier, wi.AssignedUser
FROM [WorkItem] wi
LEFT JOIN [Enumeration] enum ON enum.EnumerationID = wi.TierId
INNER JOIN [DisplayString] ds ON ds.ElementID=enum.EnumerationID
WHERE wi.ClassId = 'A604B942-4C7B-2FB2-28DC-61DC6F465C68'
AND wi.StatusId NOT IN('2b8830b6-59f0-f574-9c2a-f4b4682f1681','bd0ae7c4-3315-2eb3-7933-82dfc482dbaf')
AND ds.LocaleID='ENU'