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

Is there a way to pull in the date a user was assigned to an issue in a report column?

Avatar

Level 2

Is there column or a way we can pull in the date of when a user was assigned to an issue?

Topics

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

3 Replies

Avatar

Level 2

I'm trying to figure out something similar: how to add a column to a report to view the date a specific team was assigned to tasks.

The closest answer I've found is listed here under "Assignment Name or Role and Week Days Elapsed": Text Mode in Views Using Collections (wf-pro.com)

valueexpression=CONCAT(IF(ISBLANK({assignedTo}.{name}),{role}.{name},{assignedTo}.{name})," - ",CONCAT(ROUND(WEEKDAYDIFF({entryDate},$$NOW),0), " Days"))

listdelimiter=

listmethod=nested(assignments).lists

valueformat=HTML

displayname=Assignment and Weekdays to Now

textmode=true

type=iterate

@NRYN R - inactive‚ - I love your wf-pro site, let us know if you have any recommendations for our scenarios!

Avatar

Community Advisor

there's a new report type that just came out with the last product release (the journal entry report) right here: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FPr...,

here: https://vimeo.com/513511262/466fe94246, and

here: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FRe...

I'm still learning about this so I'm probably not the best person to be giving advice, but just briefly, you could try filtering on

1) Journal Entry > Field Name = assignedToID (this will at least pull in the first user that was assigned to your issues)

2) Journal Entry > Project ID = name of some project where you know someone's been assigned today

3) Journal Entry > Entry Date = $$TODAY

Then run the report and check out what it says in the Scope and Change Type fields. For my project, I would be looking to additionally filter on Journal Entry > Scope = Request (you might be looking to put "Issue" in here) and Journal Entry > Change Type = Add or Edit (or both)

Avatar

Level 9
Level 9

In an Issue or Task report, you can add a column with the below text mode:

displayname=Assignment Entry Dates

listdelimiter=<div>

listmethod=nested(assignments).lists

textmode=true

type=iterate

valueexpression=CONCAT(IF(ISBLANK({assignedTo}.{name}),{role}.{name},{assignedTo}.{name})," - ",{entryDate})

valueformat=HTML

Jessica was pretty close in looking at that example she mentioned; all that was needed was to adjust the valueexpression.

I tried to adjust it to show the date of Team assignments, and strangely it doesn't work as expected. I'm able to show the assigned team name using valuefield=team:name, but any valueexpression using {team}.{name} (or even {teamID}) won't display the team as part of the expression.