Display Last Note on Project in a Task Report | Community
Skip to main content
A
AndrewCa2
Level 2
June 23, 2017
Question

Display Last Note on Project in a Task Report

  • June 23, 2017
  • 3 replies
  • 776 views
Hi we have the following code in a Project report and it results in the column displaying the last note on the project. displayname=Last Update linkedname=lastNote namekey=view.relatedcolumn namekeyargkey.0=lastNote namekeyargkey.1=noteText querysort=lastNote:noteText textmode=true usewidths=true valueexpression=IF(!ISBLANK({lastNote}.{noteText}),CONCAT({lastNote}.{noteText}," [",{lastNote}.{owner}.{name},", ",{lastNote}.{entryDate},"]"),"") valueformat=HTML width=200 What I need to do is add this to a Task report, but still have it show the last note on the project (not the last note on the task). Is this possible to do? Can anyone suggest the code snippet which would accomplish this? Thanks for your help. Andrew
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

A
AndrewCa2Author
Level 2
June 23, 2017
Nevermind, I figured it out...
Doug_Den_Hoed_AtAppStore
Community Advisor
Doug_Den_Hoed_AtAppStoreCommunity Advisor
Community Advisor
June 23, 2017
Hi Andrew. Just to confirm, to fix it, did you just add the "project" prefix, since it was a level up? Regards, Doug
A
AndrewCa2Author
Level 2
June 23, 2017
Sort of, but I had to add a few extra things, here is what worked... displayname=Last Note linkedname= project namekey=view.relatedcolumn namekeyargkey.0=project namekeyargkey. 1 =lastNote namekeyargkey. 2 =noteText querysort= project: lastNote textmode=true usewidths=true valueexpression=IF(!ISBLANK( {project}. {lastNote}.{noteText}),CONCAT( {project}. {lastNote}.{noteText}," [", {project}. {lastNote}.{owner}.{name},", ", {project}. {lastNote}.{entryDate},"]"),"") valueformat=HTML width=200
Terms & ConditionsAccessibility statement

Loading footer...