Trying to get a customized project report column to display in an issue report | Community
Skip to main content
P
Pat_Paterson
New Participant
May 20, 2022
Solved

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

  • May 20, 2022
  • 2 replies
  • 971 views

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.
Best answer by skyehansen

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

2 replies

skyehansen
skyehansenAccepted solution
New Participant
May 20, 2022

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

    P
    Pat_PatersonAuthor
    New Participant
    May 20, 2022

    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

      skyehansen
      skyehansen
      New Participant
      May 20, 2022

      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!

        imgrund
        imgrund
        Employee
        May 20, 2022

        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

          Terms & ConditionsAccessibility statement

          Loading footer...