Jump to content

Alberto M

Hornbill Users
  • Posts

    341
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by Alberto M

  1. @AndyHill, the way I've done that was using a SQL script in the admin direct SQL to list the boards with their owners. Something like this:

    SELECT B.h_id, B.h_name, B.h_owner, A.h_account_status, B.h_lastupdated, B.h_archived, B.h_bm_id, COUNT(C.h_id) AS ncards
    FROM h_itsm_boards B
    LEFT OUTER JOIN h_itsm_board_cards C
        ON B.h_id = C.h_board_id
    LEFT OUTER JOIN h_sys_accounts A
        ON B.h_owner = A.h_user_id
    WHERE C.h_archived <> '1'
        AND h_bm_id = '0'
    GROUP BY B.h_id, B.h_name, B.h_owner, B.h_lastupdated, B.h_archived, B.h_bm_id


     

    • Like 1
  2. @samwoo

    Be aware that the company field in the request could not be 100% reliable depending on the company you have set in the users and in the sites, as the logic behind it is:
     

    1. When a request is raised and a user selected as the customer on the request the values populated for h_company_id and h_company_name will be from the companies associated with that user

    2. When on an existing request, when a customer of the request is changed with another user the values populated for h_company_id and h_company_name will be from the user associated site specifically the company associated with that site. 

     

    We've detected this because in some requests we found that the company was not what we were expecting (we can have users from different companies associated to the same site).

     

    Regards,

    A

    • Thanks 1
  3. Hi all.

    We have some of our email templates - mostly the ones used to send email messages from requests and notifications of updates in requests to the users - where we have set the request owner picture. We found this to be important, as the contact with the users became more - how can we say? - personal, more face-to-face.

    For this, we use a "trick" that, after the recent removal of PHP from the Hornbill, it doesn't work anymore. We were using this html within our email template:

    https://live.hornbill.com/........../lib/espphplib/index.php/images/user_image?code={{owner.H_icon_ref}}_64x64.jpg

    From what I've understood, now, even if I use the analyst image URL, it doesn't work unless you are logged in into Hornbill - for security reasons - which will not happen to most users that aren't navigating in Hornbill and receive the email using Outlook.

    Is there someone here using the analysts images in email templates using a successful method for this?

    Thanks and regards,

    Alberto

    image.png.1446440ab5e1434157c26cb60ab69e9b.png

     

  4. Hi.

    Well... I think I can past this request here. :)

    I have several colleagues asking if the requests list summary can be larger. The current summary appears larger than the new one. It could not be that much larger, but it makes difference when looking to a requests list with several requests where the summary is similar.

    Thanks

     

    image.png.1de255b74794750aab68680ffe569b07.png

×
×
  • Create New...