报告:合并的任务和问题查看和分组

此工作项报告同时显示用户已接受在一个报告中处理的任务和问题。 最好与自定义分组结合使用。

此报表在视图中使用sharecol=true组合同一列标题下的多个字段。 有关sharecol标记的详细信息,请参阅视图:合并一个共享列中多个列的信息

TIP
工作项视图仅显示分配给他们的用户已接受的任务和问题。 此报告不显示尚未从“工作请求”或“团队请求”列表移动到用户工作列表的工作项。

work_item_report.png

访问要求

您必须具有以下权限才能执行本文中的步骤:

Adobe Workfront计划*
任何
Adobe Workfront许可证*
计划
访问级别配置*

编辑对报告、功能板和日历的访问权限

编辑对筛选器、视图、分组的访问权限

注释

如果您仍然没有访问权限,请咨询Workfront管理员是否对您的访问级别设置了其他限制。 有关Workfront管理员如何修改您的访问级别的信息,请参阅创建或修改自定义访问级别

对象权限

管理报表的权限

有关请求其他访问权限的信息,请参阅请求访问对象

*要了解您拥有什么计划、许可证类型或访问权限,请与Workfront管理员联系。

构建具有组合任务和问题视图和分组的报告

要使用此视图生成报表,请执行以下操作:

  1. 从​ 主菜单 中,单击​ 报表

  2. 单击​ 新建报告,然后从下拉菜单中选择对象​ 工作项

  3. 在​ 列预览 ​区域,单击唯一显示的列的标题。

  4. 单击​ 切换到文本模式

  5. 将鼠标悬停在文本模式区域上,然后单击​ 单击以编辑文本

  6. 删除在​ 文本模式 ​框中找到的文本,然后将其替换为以下代码:

    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. (可选)单击​ 分组 ​以向报表中添加分组。

  8. (可选)如果要添加分组,请单击​ 切换到文本模式

  9. (可选)将分组文本模式区域中的文本替换为以下代码:

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

    此分组将所有任务和问题分组在一起。

  10. 单击​ 保存+关闭

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