Jump to content

Trying to report Requests with certain active Tasks


Recommended Posts

Hi all,

I'm attempting to create a report showing Requests which have a particular (BPM-created) Task outstanding.

There's no problem finding the task data in h_sys_tasks table and applying appropriate filters, but Request is only accessible in the Object Reference URN, but I can't map the URN (e.g. urn:sys:entity:com.hornbill.servicemanager:Requests:SR00079323) to the Requests table to extract request data.

I had considered linking via the BPM Instance data, but while the BPM Instance data does hold the Request ID, the BPM reference in the Task data is also in a format (e.g. BPM:BPM20220413000133) that I can't use to join to the BPM Instance ID field (and I would prefer to avoid any unnecessary table joins if possible, anyway.)

Can anyone suggest how I might be able to create a report with this sort of data?

Thanks

Link to comment
Share on other sites

You can join the Object Reference URN with the Social Object Ref in the Requests table:

 

image.png.91f9ba34d7f73582ebf3c933a1587e5c.png

Or a different way (not needed but might help with other situations):

image.thumb.png.6f8631db5ae2bd6b1dcc780a363b27f1.png

Link to comment
Share on other sites

Thanks @Met, that's sorted it. I'd not looked at the Social Object Ref as we don't use the social features in Hornbill. I'll make a note of this solution (and your other suggestion) for future reference.

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