We are looking to report the latest document uploaded to an issue with date/time stamp. Thoughts? | Community
Skip to main content
Level 5
December 16, 2020
Solved

We are looking to report the latest document uploaded to an issue with date/time stamp. Thoughts?

  • December 16, 2020
  • 1 reply
  • 672 views

We currently use text mode to add the "name" of the document attached to the request. We would like to add the date/time to report out when a document or replacement document use uploaded compared to the planned completion date.

This is the current text mode:

displayname=Attached Documents

listdelimiter=<br>

listmethod=nested(documents).lists

textmode=true

type=iterate

valuefield=name

valueformat=HTML

Suggestions? Thank you in advance.

Best answer by Richard_Le_

Hi Dawnmarie,

If i've understood your post correctly, you would like your report to show the name of documents added to an issue and the date it was uploaded. If that's the case, the below text mode should do it:

displayname=Attached Documents

listdelimiter=<br>

listmethod=nested(documents).lists

textmode=true

type=iterate

valueexpression=CONCAT({name}," - ",{currentVersion}.{entryDate})

valueformat=HTML

Hope that helps!

Best Regards,

Rich.

1 reply

Richard_Le_Community AdvisorAccepted solution
Community Advisor
December 16, 2020

Hi Dawnmarie,

If i've understood your post correctly, you would like your report to show the name of documents added to an issue and the date it was uploaded. If that's the case, the below text mode should do it:

displayname=Attached Documents

listdelimiter=<br>

listmethod=nested(documents).lists

textmode=true

type=iterate

valueexpression=CONCAT({name}," - ",{currentVersion}.{entryDate})

valueformat=HTML

Hope that helps!

Best Regards,

Rich.

Level 5
January 5, 2021

Thank you! This worked like a charm. Sorry for the delayed reply. =D