how-to Reporting custom field in request populated from a simple list

[gwynne]

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]

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.