Note text name and date on report | Community
Skip to main content
J
JanelleHi
Level 4
November 3, 2022
Solved

Note text name and date on report

  • November 3, 2022
  • 1 reply
  • 700 views

I'm creating a Note Report to show all of the updates added by a user across our WF instance- grouped by project. I'd like to add the user's name and entry date to the note column. I rather have it all in the one column than to have separate columns for the note owner and note entry date, if possible.

 

For instance, for the parent note column, I used this code so the person's name who entered the parent note appears at the end of the note along with the date:

displayname=Parent Note Text
linkedname=parentNote
namekey=view.relatedcolumn
namekeyargkey.0=parentNote
namekeyargkey.1=noteText
querysort=parentNote:noteText
textmode=true
valueexpression=IF(!ISBLANK({parentNote}.{noteText}),CONCAT({parentNote}.{noteText}," [",{parentNote}.{owner}.{name},", ",{parentNote}.{entryDate},"]"),"")
valueformat=HTML

 

I was able to adapt the valueexpression  line from a similar report I have that includes the 'last note'. However, when I try to edit the valueexpression for just the noteText column, it doesn't work. I've tried removing {parentNote}, or replacing it with {noteText} and both result in a blank column. Thoughts on how I can adapt for the Note text column? Thanks in advance.

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 HollySe

Hi Janelle! 

 

This may take some Frankensteining depending on your columns but should give you the general idea. This code combines column 2 & 3.

 

FIRST Replace your last line with: valueformat=customDataLabelsAsString

 

THEN add the following below:

 

column.2.valuefield=USERNAME

column.2.linkedname=project

column.2.valueformat=customDataLabelsAsString

column.2.displayname=NAME

column.2.namekey=view.relatedcolumn

column.2.textmode=true

column.2.sharecol=true

column.2.namekeyargkey.0=project

column.2.namekeyargkey.1=USERNAME

column.2.querysort=DE:USERNAME

column.2.shortview=true

column.3.displayname=ENTRY DATE

column.3.linkedname=project

column.3.namekey=view.relatedcolumn

column.3.namekeyargkey.0=project

column.3.namekeyargkey.1=ENTRYDATE

column.3.querysort=DE:ENTRYDATE

column.3.shortview=true

column.3.valuefield=ENTRYDATE

column.3.valueformat=customDataLabelsAsString

1 reply

HollySe
HollySeAccepted solution
Level 3
November 4, 2022

Hi Janelle! 

 

This may take some Frankensteining depending on your columns but should give you the general idea. This code combines column 2 & 3.

 

FIRST Replace your last line with: valueformat=customDataLabelsAsString

 

THEN add the following below:

 

column.2.valuefield=USERNAME

column.2.linkedname=project

column.2.valueformat=customDataLabelsAsString

column.2.displayname=NAME

column.2.namekey=view.relatedcolumn

column.2.textmode=true

column.2.sharecol=true

column.2.namekeyargkey.0=project

column.2.namekeyargkey.1=USERNAME

column.2.querysort=DE:USERNAME

column.2.shortview=true

column.3.displayname=ENTRY DATE

column.3.linkedname=project

column.3.namekey=view.relatedcolumn

column.3.namekeyargkey.0=project

column.3.namekeyargkey.1=ENTRYDATE

column.3.querysort=DE:ENTRYDATE

column.3.shortview=true

column.3.valuefield=ENTRYDATE

column.3.valueformat=customDataLabelsAsString

Terms & ConditionsAccessibility statement

Loading footer...