Reporting on Category Code

[Lauren]

Hi

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

Thanks
Lauren

[Steven Boardman]

@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