Does anyone have the text code to add a column in a report for the date a predecessor task was completed? | Community
Skip to main content
T
TracyPa2
New Participant
June 20, 2020
Solved

Does anyone have the text code to add a column in a report for the date a predecessor task was completed?

  • June 20, 2020
  • 5 replies
  • 1158 views

One of our users would like a column added to his task report that displays the date the predecessor task was completed.

The standard list of column options does not include this. Do any of you have a text mode way of accomplishing this?

I come from a design background and not coding so this is my weakness. But I really enjoy trying to solve these issues and build our best version of WF possible.

I appreciate any help you can provide.

Thank you

    Best answer by TracyPa2

    I did some digging through articles on here. I couldn't find exactly what i was looking for but i was able to find a code that I altered slightly and it works.

    I'm going to leave this post up in case this helps anyone else. Here is the code I used:

    displayname=Predecessors Completion Dates

    listdelimiter=<br>

    listmethod=nested(predecessors).lists

    textmode=true

    type=iterate

    valueexpression={predecessor}.{actualCompletionDate}

    valueformat=HTML

    5 replies

    M
    MartaBukwaś
    New Participant
    June 22, 2020

    Thank you for sharing, Tracy! I will try it out as we've been looking for a way to display this data for a while!

    N
    NRYNR
    New Participant
    June 21, 2020

    Good stuff everyone. This solution has been documented in the WFPro Text Mode Examples report.

      kynabaker16
      kynabaker16
      Employee
      June 20, 2020

      I second Doug! Well done, Tracy. You sound like you're getting more and more familiar with this type of work every day, even though it isn't your background.

      Doug_Den_Hoed__AtAppStore
      Doug_Den_Hoed__AtAppStore
      New Participant
      June 20, 2020

      Well done Tracy!

      Since you enjoy noodling these out, I invite you to review this related post, which builds on the concept you just applied.

      Regards,

      Doug

      T
      TracyPa2Author
      New Participant
      June 21, 2020

      Hmmm, I've been trying this on several different reports and even created a brand new project report but the fields are always empty. Haven't been able to solve the riddle yet...

      T
      TracyPa2AuthorAccepted solution
      New Participant
      June 20, 2020

      I did some digging through articles on here. I couldn't find exactly what i was looking for but i was able to find a code that I altered slightly and it works.

      I'm going to leave this post up in case this helps anyone else. Here is the code I used:

      displayname=Predecessors Completion Dates

      listdelimiter=<br>

      listmethod=nested(predecessors).lists

      textmode=true

      type=iterate

      valueexpression={predecessor}.{actualCompletionDate}

      valueformat=HTML

        Terms & ConditionsAccessibility statement

        Loading footer...