Expand my Community achievements bar.

Join us LIVE in San Francisco on November 14th for Experience Makers The Skill Exchange. Don't miss out on this free learning event!

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

Community Advisor

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.

If you like my content, please take a moment to view and vote on my Idea Requests: https://tinyurl.com/4rbpr7hf