Expand my Community achievements bar.

Do you have questions about the migration to Adobe Business Platform? Come join our upcoming coffee break and ask away!

Text mode help - request report pulling info from projects

Avatar

Level 4

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

 

Screenshot 2023-11-06 at 3.08.34 PM.png

 

1 Reply

Avatar

Community Advisor

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 : )