Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

List predecessor and successor task in an assignment report?

Avatar

Level 10

I'm trying to list task predecessor and assignedTo name, and successor task and assignedTo name for a given task in an assignment report. (not a task report)

I can get predecessor names in a task report using the following:

valueexpression=CONCAT({predecessor}.{name})

listdelimiter=<br>

listmethod=nested(predecessors).lists

valueformat=HTML

displayname=Predecessor Name

textmode=true

type=iterate

And predecessor assignee:

displayname=Predecessor Assignee

listdelimiter=<br>

listmethod=nested(predecessors).lists

textmode=true

type=iterate

valueexpression=CONCAT({predecessor}.{assignedTo}.{name})

valueformat=HTML

In an assignment report I would assume I could add "task" before predecessor but that doesn't work.

Like: valueexpression=CONCAT({task}.{predecessor}.{name})

The only other way I can think of is a task form with calc fields for previous tasks and next task and their assignees, then display that on an assignment report.

There has to be an easier way though. Thanks

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

nothing additional is needed for your valueexpression lines. Those should have carried over as-is. The only add was the “task” on the collection line.

e.g.

displayname=Predecessor

listdelimiter=<br>

listmethod=nested(task.predecessors).lists

textmode=true

type=iterate

valueexpression=CONCAT({predecessor}.{name})

valueformat=HTML

View solution in original post

5 Replies

Avatar

Community Advisor

it's pretty close. The only thing you need to change is your collection -- this should be task.predecessors rather than predecessors. e.g. listmethod=nested(task.predecessors).lists

Avatar

Level 10

So hopeful… but no go.

This is what I just tried:

valueexpression=CONCAT({task}.{predecessor}.{name})

listdelimiter=<br>

listmethod=nested(task.predecessors).lists

valueformat=HTML

displayname=Predecessor Name

textmode=true

type=iterate

Avatar

Correct answer by
Community Advisor

nothing additional is needed for your valueexpression lines. Those should have carried over as-is. The only add was the “task” on the collection line.

e.g.

displayname=Predecessor

listdelimiter=<br>

listmethod=nested(task.predecessors).lists

textmode=true

type=iterate

valueexpression=CONCAT({predecessor}.{name})

valueformat=HTML

Avatar

Level 3

Working, but the Predecessor assignee is not including the team assignment. Our task includes a resource and a team. Any suggestions? Also, wondering how I could include the Iteration of the predecessor task. Any help appreciated.