How to combine Request and Task/ activities table

[Joyce]

Hi,

I am trying to get a report on task/activities, associated with change request. For this I think I need to combine h_itsm_requests with h_sys_tasks. I have try using 'request ID is like h_obj_ref_urn ' , also  'BPM ID is like h_sys_reference' to join the tables but I am not getting any value.

 

How can I join these two tables correctly?

 

Thanks.

Joyce

 

[Steven Boardman]

@Joyce you can use the following join

CONCAT("urn:sys:entity:com.hornbill.servicemanager:Requests:",h_itsm_requests.h_pk_reference)

Hope that helps

Steve