Jump to content

Widgets - Display open and on-hold incidents/service requests


dwalby

Recommended Posts

Hi all,

I've created a dashboard to display are call stats but having some trouble getting the SQL query to show open and on-hold requests. Below is what I have currently, but when I add  OR h_status='status.onhold it either breaks the widget to show no count, or shows an incorrect figure:

Number of Open Incidents (Using SQL query: h_status='status.open' AND h_requesttype='incident') 

Number of Open Service Requests (Using SQL query: h_status='status.open' AND h_requesttype='Service Request')

Total Open Incidents & Service Requests (Using SQL query: h_status='status.open' AND h_requesttype='incident' OR h_requesttype='service request')

Any suggestions? I'm sure it's something simple, SQL isn't my strong point!

Link to comment
Share on other sites

Hi @dwalby you could try this 

h_status in ('status.open','status.onHold') and h_requesttype='Incident'

h_status in ('status.open','status.onHold') and h_requesttype='Service Request'

h_status in ('status.open','status.onHold') and h_requesttype IN ('Incident','Service Request')

You might also want to consider status.new if you are using that status for new requests via the business process engine 

Hope that helps 

Steve

  • Like 1
Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...