Trying to get a customized project report column to display in an issue report | Community
Skip to main content
Pat_Paterson
Level 4
May 20, 2022 4:57 PM UTC
Solved

Trying to get a customized project report column to display in an issue report

The customized project report column uses the following code:

displayname=Current Task Status Details

listdelimiter=<div>

listmethod=nested(tasks).lists

textmode=true

type=iterate

usewidths=true

valueexpression=IF({numberOfChildren}=0,IF({canStart},IF(CONTAINS("CPL",{status}),"",CONCAT({name}," - ",{assignedTo}.{name}," - ",{plannedCompletionDate}))))

valueformat=HTML

width=300

However I haven't been able to get to display in a correlating issues/requests report

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
skyehansen
skyehansenAccepted solution
Level 4
May 20, 2022 6:07 PM UTC

I haven't tried this out myself (Friday laziness) but have you tried swapping out the listmethod line? Like try using:

listmethod=nested(project.tasks).lists

View reply

5 replies

skyehansen
skyehansenAccepted solution
Level 4
May 20, 2022 6:07 PM UTC

I haven't tried this out myself (Friday laziness) but have you tried swapping out the listmethod line? Like try using:

listmethod=nested(project.tasks).lists

Translate
    Pat_PatersonAuthor
    Level 4
    May 20, 2022 7:53 PM UTC

    Thanks Skye! this put me on the right track. I went with the following code and got it to display the way we wanted.

    listmethod=nested(resolveProject.tasks).lists

    Translate
      skyehansen
      skyehansen
      Level 4
      May 20, 2022 8:32 PM UTC

      ah I see, you actually want the project that the request was converted to (I thought you wanted the project the request was logged in). Yep, that's the ticket!

      Translate
        imgrund
        imgrund
        Employee
        May 20, 2022 5:47 PM UTC

        Hi Seth - Unfortunately, you won't be able to convert this to an issue report. Tasks are not a "collection" on the issue object type. [Collections are the many to one relationships an object has]

        Not sure what your end goal is, but in the past I have kind of "faked" a request report but doing a project report but I just filter it on the Converted Issue Originator where it equal $$USER.ID. So my requesters can see only the projects that were converted from requests they made and I can showcase all the project dates and info I need to share.

        Hope that helps

        Translate
          Terms & ConditionsAccessibility statement

          Loading footer...