Pulling most recent project update into a report | Community
Skip to main content
Level 2
April 16, 2024
Solved

Pulling most recent project update into a report

  • April 16, 2024
  • 1 reply
  • 650 views

I may have asked this before, but I can't find my original post.

 

I have a task report and I added a column to pull the project update notes.  I thought that it would pull the most recent update note, but it's not.  It's pulling the first note.  Do you know how I can have the most recent update not show in my report?

 

This is the text code for the updates note column.  Do I need to modify this code or is there something different that I have to do or it not possible to do what I want?

 

displayname=
linkedname=project
namekey=view.relatedcolumn
namekeyargkey.0=project
namekeyargkey.1=TDM Update Notes
querysort=DE:project:TDM Update Notes
valuefield=project:TDM Update Notes
valueformat=customDataLabelsAsString

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 NicholeVargas

@karenne2 You can use the field for Last Note - Note Text to pull in the most recent update on the project. Your text mode would look like this:

displayname=Last Update on Project textmode=true valuefield=project:lastNote:noteText valueformat=HTML

  

1 reply

NicholeVargas
Adobe Employee
NicholeVargasAdobe EmployeeAccepted solution
Adobe Employee
April 24, 2024

@karenne2 You can use the field for Last Note - Note Text to pull in the most recent update on the project. Your text mode would look like this:

displayname=Last Update on Project textmode=true valuefield=project:lastNote:noteText valueformat=HTML