HTML isn't actually returning HTML

[Lila_Whitney]

Could someone check my text mode? Thanks in advance

displayname=Last Note

querysort=lastNote:entryDate

textmode=true

usewidths=true

valueexpression=IF(LEN({lastNote}.{noteText})>140, CONCAT(SUBSTR({lastNote}.{noteText},0,139),"...(open for more) -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate}), IF(LEN({lastNote}.{noteText})>0, CONCAT({lastNote}.{noteText}," -- ", {lastNote}.{owner}.{name}," on ", {lastNote}.{entryDate})))

valueformat=HTML

width=300

[skyehansen]

this is working for my instance. Can you share what your errors actually are? (also helpful is what kind of report you are putting this on. For example if you put it in a project report this will pull updates posted to the project but not any of the tasks or issues inside the project... so if you're expecting anything like that, this would be the wrong code to use.)

[Lila_Whitney]

Thanks, Skye. This for a project report. It's pulling in the last note, but the text is not clickable.

[TealeMcCleaf]

@Lila Whitney‚

It looks like you want to create a link but you haven't indicated where the URL is for that link. Do you have a field that is generating the URL or what are you expecting the URL to point to?

[Lila_Whitney]

It would be the thread link to the Last Note

[TealeMcCleaf]

Try adding this text mode code and see if it renders

linkedname=html({lastNote}.{noteText})

link.url=({lastNote}.{noteText})

I don't know if it will work because I've only ever pointed mine to a custom field but give it a shot.

Good luck!

[Lila_Whitney]

no dice, but thank you!

[Heather_Kulbacki]

This is what we use the create a link in a report to a note - we put the note and the link in separate columns:

displayname=Comment Link

textmode=true

valueexpression=IF(ISBLANK({taskID}),CONCAT("https://yourdomain.my.workfront.com/project/",{projectID},"/updates?commentID=",{ID}),CONCAT("https://yourdomain.my.workfront.com/task/",{taskID},"/updates?commentID=",{ID}))

valueformat=HTML