Display Issues on a Project Report | Community
Skip to main content
Level 3
May 12, 2021
Solved

Display Issues on a Project Report

  • May 12, 2021
  • 1 reply
  • 924 views

I have automated a project status report to go to our requestors. They don't have access to projects, but I would like for them to be able to link back to their original issue to add in any necessary notes or documents.

I remember completing a similar exercise in bootcamp, but I cannot for the life of me remember how.

Can someone help me with a code to display the originating issue on a project report?

Thank you!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Richard_Le_

No problem Vanessa,

The the following text mode instead. This should display the original issue's name as a clickable link

displayname=

linkedname=convertedOpTask

namekey=view.relatedcolumn

namekeyargkey.0=convertedOpTask

namekeyargkey.1=name

querysort=convertedOpTask:name

textmode=true

valuefield=convertedOpTask:name

valueformat=HTML

Best Regards,

Rich.

1 reply

Community Advisor
May 12, 2021

Hi Vanessa,

You shouldn't need any text mode to pull this into your report. The variable you are looking for is 'Converted Issue Name' and this should be available in the report builder interface.

Best Regards,

Rich.

VanessaTrAuthor
Level 3
May 12, 2021

Hi Richard, thanks for the reply!

I had tried that at first, but it doesn't hyperlink to the issue therefore my requestor cannot follow it back to their original request in Workfront.

Any other ideas?

Richard_Le_Community AdvisorAccepted solution
Community Advisor
May 12, 2021

No problem Vanessa,

The the following text mode instead. This should display the original issue's name as a clickable link

displayname=

linkedname=convertedOpTask

namekey=view.relatedcolumn

namekeyargkey.0=convertedOpTask

namekeyargkey.1=name

querysort=convertedOpTask:name

textmode=true

valuefield=convertedOpTask:name

valueformat=HTML

Best Regards,

Rich.