Jump to content

Alisha

Hornbill Users
  • Content Count

    307
  • Joined

  • Last visited

  • Days Won

    2

Alisha last won the day on November 15 2018

Alisha had the most liked content!

Community Reputation

29 Excellent

About Alisha

  • Rank
    Senior Member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hello, Please could we have the ability to add descriptions when linking Incidents to Problems? In the same way that we can add descriptions when adding connections to a request? Many thanks, Alisha
  2. Hello, I was just wondering if it would be possible to request custom fields on resolutions, please. What we have in mind is having an FAQ tick box that the technicians can use when they resolve the request so that we know which resolutions to turn into FAQs. This would be easier for them to do than edit the Details form and tick the box there. Many thanks, Alisha
  3. Hi @James Ainsworth, Thank you. This automation would be really helpful for us, due to the delay in us processing the email (if received out of hours) and stopping the SLA clock manually. Many thanks, Alisha
  4. Hi @James Ainsworth, Our Business Process is set up to email the supplier with the fault details after the Incident is prioritised. The email that we receive back from the supplier could happen at any time between receiving our initial email and resolution. Many thanks, Alisha
  5. Hello, We would like to put existing requests on hold based on the subject line of an email from a supplier. Is this possible to achieve within the Business Process please? If not, please could we request this as an enhancement? I've seen the 'Wait for Request Email' option, but this seems to be for when an email is sent from the request, and not the other way around. Any help would be much appreciated. Many thanks, Alisha
  6. I somehow made it work by adding: AND h_requesttype = "Incident" And removing: AND h_sub_status IN ("Parent - With Third Party", "Parent") I'm not sure why that worked but it has!
  7. Hi @Steve Giller, We have a workaround for the slideshow timing out. However, I was wondering if it would be possible to have a link/icon to dashboards/slideshows within the menu as shown above please? Many thanks, Alisha
  8. @Bob Dickinson I have also tried changing it to the following and that seems to work. WHERE h_fk_priorityname = "Critical" AND (h_fk_servicename ="Service Name 1" OR h_fk_servicename ="Service Name 2") But as soon as I remove the below, I get the error again. AND h_sub_status IN ("Parent - With Third Party", "Parent")
  9. Hi @Bob Dickinson, Thanks for your quick response. I receive the below error when I remove that one line. We do currently have an open Critical Incident and that does appear on the widget when using the full query. We do actually have two services listed, and when I removed one it started to work. Is it not possible to have the below line at the beginning? WHERE h_fk_servicename IN ('Service Name 1', 'Service Name 2') For example: SELECT h_pk_reference AS 'Open Critical Incidents', h_summary, h_fk_team_name FROM h_itsm_requests WHERE h_fk_servicename IN ("Service Name 1", "Service Name 2") AND h_fk_priorityname = "Critical" AND h_status IN ("status.new", "status.onhold", "status.open") ORDER BY h_pk_reference DESC Many thanks, Alisha
  10. Hello, I'd like a widget so we can see all Critical Incidents. My original widget is as follows and this seems to work fine. SELECT h_pk_reference AS 'Open Critical Incidents', h_summary, h_fk_team_name FROM h_itsm_requests WHERE h_fk_servicename = "IT Services" AND h_fk_priorityname = "Critical" AND h_status IN ("status.new", "status.onhold", "status.open") AND h_sub_status IN ("Parent - With Third Party", "Parent") ORDER BY h_pk_reference DESC However, when I remove one line (see below) because we don't actually want the sub-status in there, it no longer works. Does anyone know why please? SELECT h_pk_reference AS 'Open Critical Incidents', h_summary, h_fk_team_name FROM h_itsm_requests WHERE h_fk_servicename = "IT Services" AND h_fk_priorityname = "Critical" AND h_status IN ("status.new", "status.onhold", "status.open") ORDER BY h_pk_reference DESC Many thanks, Alisha
  11. We had this issue yesterday and the day before as well, but it seems to be working again today.
  12. @Steve Giller Thank you. Sorry, I couldn't find it on https://wiki.hornbill.com/index.php/Table_Info:_Main_Request_Table so thought it wasn't on that table and didn't think to check the same table on the Entity Viewer!
  13. Hello, I'd like to create a widget that displays how many requests we have with the sub-status 'Third Party'. Which table holds the sub-status information please? Many thanks, Alisha
  14. @Conor Thank you so much!
×
×
  • Create New...