Jump to content

Reporting on Custom Fields in "Details" of Requests


Lauren

Recommended Posts

Hi

We've utilised "relatedEntityData.record.h_custom_l" in our incident details form as a way of identifying whether an incident has warranted a call-out of an IT engineer or not:

590730740_callout1.PNG.741a002913d61aced4049980036eb2c7.PNG1447075106_callout2.PNG.b387610ce7cfe4bb34e968253f325a57.PNG

 

It shows as a simple check-box for the IT engineer to check if they've been called out by the business.

I need to be able to report on this, but cannot locate the table in which the custom fields available in the "Details" form are stored.

Are you able to help, please?

Thanks

Lauren

Link to comment
Share on other sites

Hi @Lauren these should all be in the h_itsm_requests table - you can use the database entity viewer in the admin tool to double check.  There are other extended tables which these are also written too but they should be in the primary requests table.

They will also be in the h_itsm_incidents in this occasion as well as the h_sm_requests_extended table, (sorry for any confusion, this is more of a legacy thing)

image.png

 

Link to comment
Share on other sites

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

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...