Is there column or a way we can pull in the date of when a user was assigned to an issue?
Topics help categorize Community content and increase your ability to discover relevant content.
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!
Views
Replies
Total Likes
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
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)
Views
Replies
Total Likes
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.
Views
Replies
Total Likes