Report by Category

This issue has been solved. See solution.
JoeBolster's picture
JoeBolster
October 14th, 2009

Im looking for a report by a specific category that gives me the created date and status of open. Im looking to get started and then add some columns to it as I go along and and see what else I need. Thank you..

Filed under: , ,
0 votes
MBHarmon's picture
MBHarmon
5 weeks 6 days ago

Try this: Select

Solution

Try this:

Select hd.Workitem_number AS 'Incident',    
 hd.Workitem_category_tree_value AS 'Category',    
 hd.Workitem_status_lookup_value AS 'Status',    
 hd.Workitem_created_on AS 'Date Created'   
From hd_Workitem_current_view hd   
Where hd.Workitem_Category_tree_Value Like '%_category%'
 AND hd.workitem_status_lookup_value != 'Closed'

It includes a Parameter for Category since I assume you'll be wanting to prompt for that.  Also our business process has multiple status types for "open" so I just made it all of them that were not closed.  Hope that helps.

- Matt

0 votes
SOLUTION