DocumentationWorkfrontWorkfront Guide

Report: combined task and issue View and Grouping

Last update: Tue May 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

This Work Item report shows both tasks and issues which users have accepted to work on in one report. It is best when combined with a custom grouping.

This report uses sharecol=true in the view to combine multiple fields under the same column header. For more information on the sharecol tag, see View: merge information from multiple columns in one shared column.

TIP
The Work Item view displays only tasks and issues that have been accepted by the users assigned to them. This report does not display work items that have not been moved from the Work Requests or Team Requests lists into the user’s Working On list.

work_item_report.png

Access requirements

You must have the following access to perform the steps in this article:

Adobe Workfront plan*
Any
Adobe Workfront license*
Plan
Access level configurations*

Edit access to Reports, Dashboards, Calendars

Edit access to Filters, Views, Groupings

NOTE

If you still don’t have access, ask your Workfront administrator if they set additional restrictions in your access level. For information on how a Workfront administrator can modify your access level, see Create or modify custom access levels.

Object permissions

Manage permissions to a report

For information on requesting additional access, see Request access to objects.

*To find out what plan, license type, or access you have, contact your Workfront administrator.

Build a report with combined task and issue View and Grouping

To build a report with this view:

  1. From the Main Menu , click  Reports.

  2. Click New Report and select the object Work Item from the drop-down menu.

  3. In the Column Preview area, click the header of the only column displayed.

  4. Click Switch to Text Mode.

  5. Mouse over the text mode area, and click Click to edit text.

  6. Remove the text you find in the Text Mode box, and replace it with the following code:

    code language-none 
    column.0.description=Task or Issue
column.0.name=Issue or Task
column.0.shortview=false
column.0.stretch=0
column.0.textmode=true
column.0.type=image
column.0.valueexpression=IF(ISBLANK({opTaskID}),'Task','Issue')
column.0.valueformat=
column.0.width=40
column.1.description=Task or Issue Name
column.1.isInlineEditable=false
column.1.link.linkproperty.0.name=ID
column.1.link.linkproperty.0.valuefield=task:ID
column.1.link.linkproperty.0.valueformat=string
column.1.link.lookup=link.view
column.1.link.valuefield=task:objCode
column.1.link.valueformat=val
column.1.listsort=nested(task).string(name)
column.1.name=Name
column.1.sharecol=true
column.1.shortview=false
column.1.stretch=50
column.1.textmode=true
column.1.valuefield=task:name
column.1.valueformat=HTML
column.1.width=120
column.2.isInlineEditable=false
column.2.link.linkproperty.0.name=ID
column.2.link.linkproperty.0.valuefield=opTask:ID
column.2.link.linkproperty.0.valueformat=string
column.2.link.lookup=link.view
column.2.link.valuefield=opTask:objCode
column.2.link.valueformat=val
column.2.linkedname=opTask
column.2.listsort=nested(opTask).string(name)
column.2.shortview=false
column.2.stretch=0
column.2.textmode=true
column.2.valuefield=opTask:name
column.2.valueformat=HTML
column.2.width=120
column.3.description=Project Name
column.3.isInlineEditable=false
column.3.link.linkproperty.0.name=ID
column.3.link.linkproperty.0.valuefield=task:projectID
column.3.link.linkproperty.0.valueformat=string
column.3.link.lookup=link.view
column.3.link.valuefield=task:project:objCode
column.3.link.valueformat=val
column.3.listsort=nested(task).nested(project).string(name)
column.3.name=Project Name
column.3.sharecol=true
column.3.shortview=false
column.3.stretch=50
column.3.textmode=true
column.3.valuefield=task:project:name
column.3.valueformat=HTML
column.3.width=120
column.4.isInlineEditable=false
column.4.link.linkproperty.0.name=ID
column.4.link.linkproperty.0.valuefield=opTask:projectID
column.4.link.linkproperty.0.valueformat=string
column.4.link.lookup=link.view
column.4.link.valuefield=opTask:project:objCode
column.4.link.valueformat=val
column.4.linkedname=opTask
column.4.listsort=nested(opTask).nested(project).string(name)
column.4.shortview=false
column.4.stretch=0
column.4.textmode=true
column.4.valuefield=opTask:project:name
column.4.valueformat=HTML
column.4.width=120
column.5.displayname=Primary Assignee
column.5.linkedname=assignment
column.5.namekey=view.relatedcolumn
column.5.namekeyargkey.0=assignment
column.5.namekeyargkey.1=assignedToID
column.5.querysort=assignment:assignedToID
column.5.textmode=true
column.5.valuefield=assignment:assignedTo:name
column.5.valueformat=HTML
column.6.displayname=Status
column.6.enumclass=com.attask.common.constants.OpTaskStatusEnum
column.6.enumtype=OPTASK
column.6.linkedname=opTask
column.6.namekey=view.relatedcolumn
column.6.namekeyargkey.0=opTask
column.6.namekeyargkey.1=status
column.6.querysort=opTask:status
column.6.sharecol=true
column.6.textmode=true
column.6.type=enum
column.6.valuefield=opTask:status
column.6.valueformat=val
column.7.displayname=
column.7.enumclass=com.attask.common.constants.TaskStatusEnum
column.7.enumtype=TASK
column.7.linkedname=task
column.7.namekey=view.relatedcolumn
column.7.namekeyargkey.0=task
column.7.namekeyargkey.1=status
column.7.querysort=task:status
column.7.textmode=true
column.7.type=enum
column.7.valuefield=task:status
column.7.valueformat=val
column.8.displayname=Priority
column.8.enumclass=com.attask.common.constants.TimelinePriorityEnum
column.8.enumtype=OPTASK
column.8.linkedname=opTask
column.8.namekey=view.relatedcolumn
column.8.namekeyargkey.0=opTask
column.8.namekeyargkey.1=priority
column.8.querysort=opTask:priority
column.8.sharecol=true
column.8.textmode=true
column.8.type=enum
column.8.valuefield=opTask:priority
column.8.valueformat=val
column.9.displayname=
column.9.enumclass=com.attask.common.constants.TimelinePriorityEnum
column.9.enumtype=TASK
column.9.linkedname=task
column.9.namekey=view.relatedcolumn
column.9.namekeyargkey.0=task
column.9.namekeyargkey.1=priority
column.9.querysort=task:priority
column.9.type=enum
column.9.valuefield=task:priority
column.9.valueformat=val
column.10.isInlineEditable=false
column.10.linkedname=task
column.10.listsort=nested(task).atDateAsAtDate(plannedStartDate)
column.10.name=Planned Start Date
column.10.sharecol=true
column.10.shortview=false
column.10.stretch=0
column.10.textmode=true
column.10.valuefield=task:plannedStartDate
column.10.valueformat=atDate
column.10.width=100
column.11.isInlineEditable=false
column.11.linkedname=opTask
column.11.listsort=nested(opTask).atDateAsAtDate(plannedStartDate)
column.11.shortview=false
column.11.stretch=0
column.11.textmode=true
column.11.valuefield=opTask:plannedStartDate
column.11.valueformat=atDate
column.11.width=1
column.12.isInlineEditable=false
column.12.linkedname=task
column.12.listsort=nested(task).atDateAsAtDate(projectedCompletionDate)
column.12.name=Planned Completion Date
column.12.sharecol=true
column.12.shortview=false
column.12.stretch=0
column.12.textmode=true
column.12.valuefield=task:projectedCompletionDate
column.12.valueformat=atDate
column.12.width=100
column.13.isInlineEditable=false
column.13.linkedname=opTask
column.13.listsort=nested(opTask).atDateAsAtDate(projectedCompletionDate)
column.13.shortview=false
column.13.stretch=0
column.13.textmode=true
column.13.valuefield=opTask:projectedCompletionDate
column.13.valueformat=atDate
column.13.width=1
column.14.isInlineEditable=false
column.14.linkedname=task
column.14.listsort=nested(task).double(percentComplete)
column.14.name=Percent Complete
column.14.sharecol=true
column.14.shortview=false
column.14.stretch=0
column.14.textmode=true
column.14.valueexpression=IF(ISBLANK({taskID}),"",{task}.{percentComplete})
column.14.valueformat=HTML
column.14.width=100
column.15.textmode=true
column.15.value=
column.15.valueformat=HTML
column.15.width=1

  7. (Optional) Click Groupings to add a grouping to the report.

  8. (Optional) If you are adding a grouping, click Switch to Text Mode.

  9. (Optional) Replace the text inside the grouping text mode area with the following code:

    code language-none 
    group.0.name=
group.0.valueexpression=IF(ISBLANK({opTaskID}),'Task','Issue')
group.0.valueformat=string
textmode=true

    This grouping groups all the Tasks together, and all the Issues together.

  10. Click Save + Close.

recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43