Project report listing issues by task name | Community
Skip to main content
ScottCraven
ScottCraven
Level 2
October 26, 2023
Solved

Project report listing issues by task name

  • October 26, 2023
  • 1 reply
  • 1124 views

Hi!  We're building a 'project finder' report to allow employees to search by any known value in order to get more info about the projects associated with those values.  We have deliverables identified by barcodes, but those issues are associated with a templated task, and I'd like to have a column that lists all issues on that task (not the entire project) to allow for search...i.e. someone knows the barcode, and can search to find what project it's on, who was assigned, when it was delivered, etc.

 

We can report ALL issues in the column with the below text mode:
displayname=Barcodes
listdelimiter=
listmethod=nested(issues).lists
textmode=true
type=iterate
valueexpression=CONCAT({name})
valueformat=HTML

 

I'm trying to narrow that to issues on a task called "Editorial", but the coding I have isn't working:

 

displayname=Barcodes TEST
listdelimiter=
listmethod=nested(issues).lists
textmode=true
type=iterate
valueexpression=IF({task}.{name}="Editorial",CONCAT({issue.name}))
valueformat=HTML

 

Anyone have an idea of where the code is going wrong?  Thanks in advance!

Scott

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 KellieGardner

I'm not sure there is a way to get issues on a task to display on a project report. Since the issues on a task are a collection to the task and not the project. 

 

Would this work if you ran a Task report instead? If you run a task report the issues tied to them will display with a collection column, you just need to change the verbiage for "issues" to "opTask" instead.

 

listmethod=nested(opTasks).lists

1 reply

KellieGardner
Community Advisor
KellieGardnerCommunity Advisor
Community Advisor
October 26, 2023

What kind of report are you running? Issue, Task, or Project?

    ScottCraven
    ScottCravenAuthor
    Level 2
    October 26, 2023

    Project report.  Sorry.  Thought I had specified.

    KellieGardner
    Community Advisor
    KellieGardnerCommunity AdvisorAccepted solution
    Community Advisor
    October 26, 2023

    I'm not sure there is a way to get issues on a task to display on a project report. Since the issues on a task are a collection to the task and not the project. 

     

    Would this work if you ran a Task report instead? If you run a task report the issues tied to them will display with a collection column, you just need to change the verbiage for "issues" to "opTask" instead.

     

    listmethod=nested(opTasks).lists

    Terms & ConditionsAccessibility statement

    Loading footer...