Is there a way to pull in the date a user was assigned to an issue in a report column? | Community
Skip to main content
Level 2
May 13, 2021
Question

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

  • May 13, 2021
  • 3 replies
  • 732 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Level 2
May 24, 2021

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!

skyehansen
Community Advisor and Adobe Champion
May 25, 2021

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%2FProduct_Announcements%2FProduct_releases%2F21.2_release_activity%2F21-2-reporting-management-enhancements.htm,

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

here: https://one.workfront.com/s/document-item?bundleId=the-new-workfront-experience&topicId=Content%2FReports_and_Dashboards%2FReports%2FCreating_and_Managing_Reports%2Fcreate-journal-entry-report.htm

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)

William
Community Advisor
Community Advisor
May 25, 2021

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