Lauren Posted January 14, 2020 Posted January 14, 2020 Hi Is there a field that stores the a category's code, rather than ID? Thanks Lauren
Steven Boardman Posted January 14, 2020 Posted January 14, 2020 @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
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