Jump to content

Michael Taylor

Hornbill Users
  • Posts

    14
  • Joined

  • Last visited

Everything posted by Michael Taylor

  1. Disabling Cache in Dev Tools (F12), Network tab, seems to work as a work-around
  2. +1 here too. The service status page says all is working though.
  3. We're just getting a spinning Hornbill icon! Is anyone else having issues? Is this related to the latest release??
  4. We're experiencing this issue using both Chrome and Edge
  5. Dashboards aren't loading! When I try to open one (all) up all I get is a white page: Is anyone else experiencing issues?
  6. The dashboards don't now auto refresh either, which is disappointing. Not sure if they do in full screen mode, I don't use full screen mode. Please bring back the old dashboard functionality
  7. Hiya, also noting the message about the admin tool changes, we use multiple dashboards locally and operationally and need the ability to switch between them in a browser quickly and easily. I can have up to 5 dashboards open in individual browser tabs simultaneously. Unfortunately, the new dashboards in the new admin tool do not cater for this requirement There is too much 'faff' around the edges of the dashboard workspace and when you hit the 'Enter fullscreen mode' button, you lose the browsers tabs. This is a big step backwards for me Or is there some other way of being able to view the dashboards as we currently can? Thank you
  8. We're experiencing the same ... our status check suggests everything is ok ... but it clearly is not!!!
  9. Hi there, When I go to export to XLSX from Home -> System -> Data -> Database Direct, this feature is exporting into CSV. The same happens when trying to export to: JSON, XML, XLS; all are exported as CSV. Is this a known fault? If so, can you let me know when this will be resolved, please. Cheers, Michael
  10. Here you go. Current requirement is to put a link around the ticket number column. Being able to use style tags would be helpful too.
  11. Hi, How do you get a link to display in custom sql in widgets ... which are then used in dashboards? I've the following sql, but it just displays the text SELECT h1.h_linked_entity_id AS category, h3.h_summary AS cat_summary, CONCAT('<a href=''https://live.hornbill.com/bits/servicemanager/request/view/',h2.h_pk_reference,'/''>',h2.h_pk_reference,'</a>') AS ticket_number, h2.h_summary AS ticket_summary, DATE_FORMAT (h2.h_datelogged, '%Y-%m-%d') AS LOGGED_DATE, IFNULL(h2.h_fk_user_name,'USER LEFT') AS customer FROM h_sm_relationship_entities h1, h_itsm_requests h2, h_itsm_requests h3 WHERE h1.h_entity_id = h2.h_pk_reference AND h1.h_linked_entity_id = h3.h_pk_reference AND h2.h_status = 'status.open' AND h2.h_ownerid = 'some_user@an_email_address.com' AND h2.h_pk_reference LIKE 'IN%' ORDER BY h1.h_linked_entity_id ASC, h2.h_pk_reference ASC Cheers Michael
  12. Hi, not sure if this is related to the latest release, but today I can't manually refresh any widgets in my dashboards when using Google Chrome! Even a roll-over the widget header doesn't display it. Viewing the widget in Widgets, also doesn't show the Manual Refresh image in the top right. I've disabled the option, then re-enabled it and it still isn't there. Seems to be ok (ish) in IE10 .. .sometimes they display, sometimes they don't.
  13. Hi, Is it possible to convert the following sql script into a report, so that the dates in the where clause are selectable? SELECT h1.h_pk_reference AS ticket_number, h1.h_datelogged AS date_logged, h1.h_dateclosed AS date_closed, DATEDIFF(h1.h_dateclosed,h1.h_datelogged) as days_to_close, h1.h_ownername AS owner, h1.h_status AS status, h2.h_fk_childrequestid AS category_number, CONCAT(h3.h_category," > ",h3.h_summary) AS category_desc FROM h_itsm_requests h1, h_itsm_rel_requests h2, h_itsm_requests h3 WHERE h1.h_pk_reference LIKE 'IN%' AND h1.h_fk_team_name = 'Applications York' AND h1.h_pk_reference = h2.h_fk_parentrequestid AND h2.h_fk_childrequestid = h3.h_pk_reference AND h1.h_datelogged BETWEEN '2016-05-30' AND '2016-06-03'
×
×
  • Create New...