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
TracyPa2
Level 4
Jun 20, 2020 12:21 PM UTC
Solved

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

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

    TracyPa2Accepted solution
    Level 4
    Jun 20, 2020 12:47 PM UTC

    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

    View reply

    7 replies

    MartaBukwaś
    Level 2
    Jun 22, 2020 11:38 AM UTC

    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!

    Translate
    NRYNR
    Level 10
    Jun 21, 2020 3:40 AM UTC

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

    Translate
      kynabaker16
      kynabaker16
      Employee
      Jun 20, 2020 3:53 PM UTC

      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.

      Translate
      Doug_Den_Hoed__AtAppStore
      Doug_Den_Hoed__AtAppStore
      New Participant
      Jun 20, 2020 2:53 PM UTC

      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

      Translate
      TracyPa2Author
      Level 4
      Jun 21, 2020 12:48 PM UTC

      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...

      Translate
      TracyPa2AuthorAccepted solution
      Level 4
      Jun 20, 2020 12:47 PM UTC

      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

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...