Updating Dashboard to Include Other Status Lookup Values

Have you ever wanted your incidents or your queued incidents (from your team) to reflect a count of Open as well as custom status incidents.

For example, see the screen shot below. This is the Open incidents for myself and for my queue, Application Support. With a little customization to the Dashboard.ascx file I can ensure that this gives me a high level view of not just Open incidents, but incidents on HOLD or incidents with a custom status, such as Update...

Click to view.

Open your Dashboard.ascx file and find the section below.

<queries>
	<query	id="open"
		type="WorkItem"
		title="sidMyOpenTitle"
		sql="workitem_assigned_to_worker_id = $current_worker_id$ AND (workitem_status_lookup_id = 300 OR workitem_status_lookup_id = 700) " />

	<query	id="queued"
		type="WorkItem"
		title="sidQueuedTitle"
		sql="workitem_status_Lookup_id in (100, 200,  300, 500, 700)" />
	</queries>

As you can see there are 2 sections. One that handles the "open" portion, which is your Open incidents an the other that hands the "queued" incidents.

To update the file and allow the page to show the count including other status incidents, update the SQL to include (for Open) OR workitem_status_lookup_id = xyz, where xyz equals a custom status id number or a built-in status which you would like to add.

For the "queued" section you only need to add a comma and the id number for the status within the parenthesis to including it.

For your convenience, here are the built-in status ids:

100 = Planned
200 = Requested
300 = Open
400 = Resolved
500 = Hold
600 = Closed
700 = custom status value