[Linking Project and Service Manager tables for reporting]

Hi Steve

Unfortunately, I was hoping to be able to pull together all tasks for an individual or team from both Project and Service Manager into one place. 

[Linking Project and Service Manager tables for reporting]

Hi

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?

Thanks

 

[Activity View]

On 7/3/2019 at 6:16 PM, James Ainsworth said:

Hi @Darren Rose

Yes, I've fed this back to the development team and they will have a look at getting Owner added as one of the condition options.

Regards,

James

Hi @James Ainsworth - I found this thread whilst looking to set up a View of Activities created by me.  Is this still on the development team's list?

Thanks

Steve