Jump to content
Lauren

Reporting on Category Code

Recommended Posts

Hi

Is there a field that stores the a category's code, rather than ID? 

Thanks
Lauren

Share this post


Link to post
Share on other sites

@Lauren in the database, the codes (and other values relating to profiles) are held in the h_sys_profiles table, if you are using the admin tool reports, you could create a report on the h_itsm_requests table and the h_sys_profiles table, joining on the h_category_id column in the requests table with the h_id in the profiles table and then get the profile code

You do also have the h_category name value which is already in the requests table, so if you can use that you would not need to join to the profiles table.

Hope that helps

Share this post


Link to post
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...