Jump to content

Alex8000

Hornbill Users
  • Posts

    113
  • Joined

  • Last visited

  • Days Won

    2

Posts posted by Alex8000

  1. Hello all,

    We are running into an issue regarding the managing of the Timesheet Categories.
    A colleague manager of mine would like to change the assigned teams to a certain category I created. This is currently not possible.

    Will it be possible in the future for other people to change the categories and the people assigned to those categories for those they have not created themselves?

    Thank you,

    Alex

  2. Hi Ryan,

     

    Thank you, that seems to have fixed that! 

    After trying it this way I noticed 

    h_fk_servicename

    in the h_itsm_requests table. I should have looked better before trying to do it the hard way... A simple 

    WHERE h_fk_servicename = 'Swyx Hosted'

    would have sufficed.

    Thank you for looking into this, I will keep your solution in the back of my head when generating the other reports!

  3. Good Morning all,

    We hope to create a list of all requests which have tasks marked as billable for service 'X'. 

    What I have so far allows us to create a list of tasks marked as billable for clients with a specific value within a custom organization field. For example: All requests with tasks marked as billable for every client whose organization has h_custom_8 = 'Swyx Hosted'. We would rather have the report look at the actual service instead of some custom organization field which may or may not be up-to-date.

    I figured I would just join h_itsm_servicesubscriptions (h_fk_subscriberid) with h_sys_organizations (h_organization_id). 
    (and optionally h_itsm_servicesubscriptions (h_fk_serviceid) with h_itsm_services (h_pk_serviceid) for filtering on service name instead of service id.)

    When generating the report the system throws a general "Error occurred while executing generated querry" error. I think it has something to do with the joins, but have been stuck on this for a while and am open for suggestions!

    Thanks,

    Alex

    1-swyx-hosted---alle-tickets.report.txt

    1.png

    2.png

    3.png

    4.png

    5.png

    6.png

    7.png

    8.png

×
×
  • Create New...