Jump to content

Identifying Category ID for use in Pro Cap Decision Expression


Recommended Posts

Hi Kelvin,

thanks for your post.

It's possible to identify the ID's by looking at the database. All the Request/Closure categories are held in a table called h_sys_profiles.

Hornbill Administration has a feature called Database Direct which can be used to query the various Hornbill tables. Database Direct is found in the context of Instance Configuration > Data > Database Direct but will only be visible when two conditions are met:

1) You must be logged in with the "Admin" user account.

2) The system setting "security.database.allowSqlQueryOperation" must be set to "On"

If the new menu item is not immediately available after switching On the allow query setting, it may be necessary to log out of Hornbill Administration, close and open your browser, and log in again.

I hope that helps,


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...