Jump to content

HHH

Hornbill Users
  • Posts

    812
  • Joined

  • Last visited

  • Days Won

    23

Posts posted by HHH

  1. @Martyn HoughtonWe made a workaround by creating a simpleList that contained the Service Names and Id's and then using that as a picker in the intelligent capture and finally using the input from that field to populate the BPM.
    Clumsy, yes, but at least it works.
    Now we'd need the same setup for languages and timezones but preferrably those would be accessed directly from the BPM rather than through this kind of workaround

    • Thanks 1
  2. @samwoo
    Here is my workaround, adjust timestamps as needed.

    SELECT left(h_assignment_timestamp,7) as 'Month',
    h_previous_team_id as 'From Team',
    h_team_id as 'To Team',
    h_itsm_requests.h_fk_servicename as 'Service',
    count(distinct h_request_id) as 'Requests'
    FROM h_itsm_request_team_assignment JOIN h_itsm_requests ON h_itsm_request_team_assignment.h_request_id = h_itsm_requests.h_pk_reference
    WHERE h_previous_team_id <> h_team_id AND h_assignment_timestamp between '2022-01-01 00:00:00' AND '2022-10-31 23:59:59'
    group by h_previous_team_id, h_team_id, h_fk_servicename, left(h_assignment_timestamp,7)
    order by left(h_assignment_timestamp,7), h_team_id, h_previous_team_id

    • Thanks 1
  3. 14 hours ago, James Ainsworth said:

    I would be interested to understand exactly what output your are trying achieve would look like and how the report will be used.  I wasn't sure if you were looking for breaking the report into sub groups or if you are trying to specify two sets of criteria for a single group.  

    Basically what I'm out for is "show the number of tickets reassigned between teams by team and by service"

  4. @Dave LongleyFirst start by following Victor's advice above.

    Employee portal translations/texts can if needed be handled in https://live.hornbill.com/{instance}/admin/platform/customize/employee-portal/ we used translations to handle local contact information etc. not ideal but it worked OK.


    As for the internal stuff. What we did was ask our staff to check and report any mistranslations found. I then made an SQL script to run in database direct.

    SELECT * FROM h_sys_app_strings where h_value like '%[CHANGEME]%' and h_lang = 'sv'

    Change the [CHANGEME] to the string that is wrong (case sensitive) and if needed the 'sv' to whatever language code you are looking for (codes use ISO 639-1 Language Codes). The script will show application and usage of string, you can then change it manually using the GUI in the respective application.

    • Like 1
  5. @Gerry
    I think we are talking past each other here, (the problem with written posts).
    I'm not talking about the emails themselves being truncated but about the routing rule engine doing it to the email body when updating the timeline.
    Since email body is converted to text before updating the timeline it should be possible to match some kind of pattern in the text and removing anything after that.
    Sorry for being unclear

    • Like 1
  6. @James Ainsworth@Gerry
    The description provided by Gerry is correct.
    In Hornbill's email templates, the placeholder is inserted (if wanted)
    *Reply above the line---------------------------------------------Reply above the line*

    Then not the email system but Hornbill itself would when raising or updating a request from email only keep the part above the line.
    So basically the placeholder is defined by Hornbill and added to the email templates as wanted, that way only one placholder definition would need to be recognized.

    When someone emails Service Manager ad-hoc, there would of course not be anything defined but at least we would keep the multiple email threads in reply emails at bay

  7. On 4/22/2022 at 11:16 PM, James Ainsworth said:

    Hi @HHH

    With the new Date picker, the contrast between allowed and blocked days has been improved.  I just wanted to check to see if this has helped your customers?

    I'll take it that no news are good news, but your solution looks good

     

×
×
  • Create New...