Jump to content

Linking Project and Service Manager tables for reporting


Recommended Posts


I'd like to try and get some help in how to pull Project information into a report in Service Manager which is using the 'h_sys_tasks' table.

The 'Object Reference URN' field in the h_sys_tasks table displays the value in the format 'urn:sys:entity:com.hornbill.projectmanager:Projects:123

The Project ID field in the Projects table displays the same project as 123.

I suspect I would need to set some custom criteria in the table join to match the last characters of the Object Reference URN value to the Project ID field, but I'm not sure where to start.

Is this possible please?



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