Claire Holtham Posted February 1, 2017 Share Posted February 1, 2017 Afternoon, We have a requirement to be able to report on the calls for a particular section of the Council (Libraries). So we want to be able to select based on the 'customer's organisation'. In the admin module, system, organisational data, organisation = Explore NB these are not external organisations, they are internal organisations. So I can't use 'Organisation_id' or 'Customer Organisation Container ID' as they are blank. Can you advise which tables this sits in so I can join it to the customer id in the main H_itsm_requests table please. I've tried browsing round but cannot find it. cheers Claire Link to comment Share on other sites More sharing options...
Claire Holtham Posted February 1, 2017 Author Share Posted February 1, 2017 Scratch that I've found it: it's the intuitively named h_sys_account_groups. It would be good if more than just the main requests table was listed on the hornbill wiki. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now