Jump to content

Michael Taylor

Hornbill Users
 View Profile  See their activity

  • Posts

    14

  • Joined

  • Last visited

 Content Type 

Posts posted by Michael Taylor

    The new dashboard workspace :(

    in Service Manager

    Posted

    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 :) 

    Database Direct Export

    in System Administration

    Posted

    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

    HTML in SQL

    in Reporting

    Posted

    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

    Dashboard Widget Manual Refresh disappeared in Chrome

    in Service Manager

    Posted

    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.

    Convert a sql script to report

    in Reporting

    Posted

    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...