Jump to content

Identifying Category ID for use in Pro Cap Decision Expression


Recommended Posts

I am trying to build some Progressive capture flows and want to Branch from the Request Category selected. Is there anywhere to find out the CategoryIds for the Expression Builder


Link to comment
Share on other sites

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