Jump to content

Linking Tables


Ann
 Share

Recommended Posts

Afternoon All

Hope you are safe and well.  Please would it be possible to advise how we are able to link the 'Requests' table with the 'Timesheet Categories'.  Several of us have tried to do this but have been unable to.  Thank you.

Kind Regards

Ann

Link to comment
Share on other sites

@Ann thanks for your post.

The column in the timesheet values table called 'h_related_urn' holds the full entity urn of the request.

So to link, you'd need to do something like CONCAT("urn:sys:entity:com.hornbill.servicemanager:Requests:",request.h_pk_reference) = timesheetValue.h_related_urn

Alex

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
 Share

×
×
  • Create New...