IntegraGreg Posted January 15, 2016 Share Posted January 15, 2016 We have a requirement to produce a monthly report detailing how much time we spend working on requests (currently logged in activities). At the moment I have to produce 2 separate reports (one for h_sys_tasks and another for h_itsm_requests) as I'm unable to join the two tables. The data in h_sys_tasks has a column h_obj_ref_urn which returns values in the format "urn:sys:entity:com.hornbill.servicemanager:Requests:IN000000001", which doesn't match the values held in h_itsm_requests.h_pk_reference (IN000000001). Is there another field that I'm missing which could do this? Link to comment Share on other sites More sharing options...
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!Register a new account
Already have an account? Sign in here.Sign In Now