HTML isn't actually returning HTML | Community
Skip to main content
Lila_Whitney
Lila_Whitney
Level 4
March 4, 2022
Question

HTML isn't actually returning HTML

  • March 4, 2022
  • 2 replies
  • 1433 views

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

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

2 replies

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
March 7, 2022

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
Lila_WhitneyAuthor
Level 4
March 7, 2022

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

Lila_Whitney
Lila_WhitneyAuthor
Level 4
March 7, 2022

It would be the thread link to the Last Note

Heather_Kulbacki
Community Advisor
Heather_KulbackiCommunity Advisor
Community Advisor
March 14, 2022

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

    Terms & ConditionsAccessibility statement

    Loading footer...