Text mode help - request report pulling info from projects | Community
Skip to main content
Level 3
November 6, 2023
Question

Text mode help - request report pulling info from projects

  • November 6, 2023
  • 1 reply
  • 435 views

I have an existing request report that shows the requests with their converted projects and I would like to bring in the last note from those projects. Currently it pulls from the requests. 

 

Thanks for your help

 

 

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

1 reply

Madalyn_Destafney
Community Advisor
Community Advisor
November 6, 2023

Hi there! Here you go, you'll need to modify the column #s of course. You're pulling 'Resolve Project > Last Note ID' as a filter to start, then in text mode I modified ID to text, and also added shared columns to show last note's entry date/name in the resolving project. 
column.5.displayname=
column.5.linkedname=resolveProject
column.5.namekey=view.relatedcolumn
column.5.namekeyargkey.0=resolveProject
column.5.namekeyargkey.1=lastNote:noteText
column.5.querysort=resolveProject:lastNote:noteText
column.5.sharecol=true
column.5.textmode=true
column.5.valuefield=resolveProject:lastNote:noteText
column.5.valueformat=HTML
column.6.displayname=
column.6.linkedname=resolveProject
column.6.namekey=view.relatedcolumn
column.6.namekeyargkey.0=resolveProject
column.6.namekeyargkey.1=lastNote:owner:name
column.6.querysort=resolveProject:lastNote:owner:name
column.6.sharecol=true
column.6.textmode=true
column.6.valuefield=resolveProject:lastNote:owner:name
column.6.valueformat=HTML
column.7.displayname=Entry
column.7.linkedname=resolveProject
column.7.namekey=view.relatedcolumn
column.7.namekeyargkey.0=resolveProject
column.7.namekeyargkey.1=lastNote:note:entryDate
column.7.querysort=resolveProject:lastNote:entryDate
column.7.textmode=true
column.7.valuefield=resolveProject:lastNote:entryDate
column.7.valueformat=longAtDate

 

See here if you want to add line break between text/name/entry date info. If this helped you out, please mark correct to help others : )

If this helped you, please mark correct to help others : )