Hi WF Community, how do we directly link column value to the issue/risk page?
descriptionkey=numberOpenOpTasks
link.linkproperty.0.numberOpenOpTasks=ID
link.linkproperty.0.valuefield=ID
link.linkproperty.0.valueformat=int
link.lookup=link.view
link.valuefield=objCode
link.valueformat=val
linkedname=direct
listsort=string(name)
namekey=numberOpenOpTasks
querysort=numberOpenOpTasks
section=0
shortview=false
stretch=0
usewidths=true
valuefield=numberOpenOpTasks
valueformat=int
width=11
Solved! Go to Solution.
Views
Replies
Total Likes
Hi @A_EN,
Thank you for your question! Unfortunately, there isn't a way to hyperlink those values to take you directly to the object's "Issues" or "Risks" page. The closest thing you could try is:
1) Add 2 columns to your report.
2) Create a custom expression for each column to display the link to the "Issues" and "Risks" pages respectively. Be sure to update the domain and object as needed.
Issues page:
displayname=Issues Link
namekey=ID
querysort=ID
valueexpression=CONCAT("https://monicacardoso.my.workfront.com/project/",{ID},"/issues")
valueformat=HTML
Risks page:
displayname=Risks Link
namekey=ID
querysort=ID
valueexpression=CONCAT("https://monicacardoso.my.workfront.com/project/",{ID},"/risks")
valueformat=HTML
3) The columns will automatically calculate with the object ID. Below is an example in my instance:
The users can then click each link to be redirected (in a new tab) to the Issues and Risks page respectively.
- Monica
Views
Replies
Total Likes
Hi @A_EN,
Thank you for your question! Unfortunately, there isn't a way to hyperlink those values to take you directly to the object's "Issues" or "Risks" page. The closest thing you could try is:
1) Add 2 columns to your report.
2) Create a custom expression for each column to display the link to the "Issues" and "Risks" pages respectively. Be sure to update the domain and object as needed.
Issues page:
displayname=Issues Link
namekey=ID
querysort=ID
valueexpression=CONCAT("https://monicacardoso.my.workfront.com/project/",{ID},"/issues")
valueformat=HTML
Risks page:
displayname=Risks Link
namekey=ID
querysort=ID
valueexpression=CONCAT("https://monicacardoso.my.workfront.com/project/",{ID},"/risks")
valueformat=HTML
3) The columns will automatically calculate with the object ID. Below is an example in my instance:
The users can then click each link to be redirected (in a new tab) to the Issues and Risks page respectively.
- Monica
Views
Replies
Total Likes
Views
Likes
Replies