gwynne Posted March 3, 2016 Posted March 3, 2016 Hello we have added an extra field in the ticket which is not populated via a capture process but items are selectable via a drop down menu which sits in the simple list section. My Question is how do I report on the field? which table does this information sit it? Its the one called root cause however in future we may want to report on additional fields we add
James Ainsworth Posted March 4, 2016 Posted March 4, 2016 Hi Gwynne, I believe that the information for the custom fields that you add to a request form will be stored in the related request type table. For example, if you add a custom field to the incident form, the information that you record in that field will be stored in the h_itsm_incident table in columns titled h_custom_a, h_custom_b, etc. So, you will need a join between the request table that contains general request information, and the h_itsm_incident table. Hope that helps.
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