View: combined task and issue details in an Hour list
This hour view combines the Task and Issue Name columns, as well as the Task and Issue Planned Hours using the sharecol tag. Because an hour entry can only belong to either a task or issue, both objects cannot appear in the same column at the same time. Each line of the view populates with the information from either a Task or an Issue.
To learn more about the sharecol tag, see View: merge information from multiple columns in one shared column.
Access requirements
You must have the following access to perform the steps in this article:
| table 0-row-2 1-row-2 2-row-2 3-row-2 layout-auto html-authored no-header | |
|---|---|
| Adobe Workfront plan | Any |
| Adobe Workfront license* |
New:
Current:
|
| Access level configurations |
Edit access to Reports, Dashboards, Calendars to modify a report Edit access to Filters, Views, Groupings to modify a filter |
| Object permissions | Manage permissions to a report |
*For information, see Access requirements in Workfront documentation.
View combined task and issue details in an Hour list
-
Go to a list of hours.
-
From the View drop-down menu, click New View.
-
In the Column Preview area, eliminate all columns except for one.
-
Click the header of the remaining column, then click Switch to Text Mode > Edit Text Mode.
-
Remove the text you find in the Edit Text Mode box, and replace it with the following code:
code language-none column.1.querysort=project:name column.1.shortview=false column.1.stretch=0 column.1.valuefield=project:name column.1.valueformat=HTML column.1.width=100 column.2.description=Task or Issue column.2.link.linkproperty.0.name=ID column.2.link.linkproperty.0.valuefield=task:ID column.2.link.linkproperty.0.valueformat=int column.2.link.lookup=link.view column.2.link.valuefield=task:objCode column.2.link.valueformat=val column.2.linkedname=task column.2.listsort=nested(task).string(name) column.2.name=Task or Issue column.2.querysort=task:name column.2.sharecol=true column.2.shortview=false column.2.stretch=0 column.2.valuefield=task:name column.2.valueformat=HTML column.2.width=100 column.3.descriptionkey=optask column.3.link.linkproperty.0.name=ID column.3.link.linkproperty.0.valuefield=opTask:ID column.3.link.linkproperty.0.valueformat=int column.3.link.lookup=link.view column.3.link.valuefield=opTask:objCode column.3.link.valueformat=val column.3.linkedname=optask column.3.listsort=nested(opTask).string(name) column.3.namekey=opTask column.3.querysort=opTask:name column.3.shortview=false column.3.stretch=0 column.3.valuefield=opTask:name column.3.valueformat=HTML column.3.width=1 column.4.valuefield=task:work column.4.sharecol=true column.4.linkedname=task column.4.valueformat=doubleAsInt column.4.namekey=view.relatedcolumn column.4.querysort=task:work column.4.textmode=true column.4.namekeyargkey.0=task column.4.namekeyargkey.1=work column.4.displayname=Planned Effort column.5.displayname=Planned Effort column.5.viewalias=opTask:workrequired column.5.linkedname=opTask column.5.valuefield=opTask:workRequired column.5.valueformat=compound column.5.querysort=opTask:workRequired column.5.namekeyargkey.0=opTask column.5.namekeyargkey.1=workrequired column.5.namekey=view.relatedcolumn column.5.textmode=true column.6.descriptionkey=hours column.6.linkedname=direct column.6.listsort=doubleAsDouble(hours) column.6.namekey=hours.abbr column.6.querysort=hours column.6.shortview=false column.6.stretch=0 column.6.valuefield=hours column.6.valueformat=doubleAsString column.6.width=75 column.7.descriptionkey=entrydate column.7.linkedname=direct column.7.listsort=atDateAsAtDate(entryDate) column.7.namekey=entrydate.abbr column.7.querysort=entryDate column.7.shortview=false column.7.stretch=0 column.7.valuefield=entryDate column.7.valueformat=atDate column.7.width=75 column.8.descriptionkey=description column.8.linkedname=direct column.8.listsort=string(description) column.8.namekey=description.abbr column.8.querysort=description column.8.shortview=false column.8.stretch=0 column.8.valuefield=description column.8.valueformat=HTML column.8.width=150 -
Click Done > Save View.
-
(Optional) Update the view name, then click Save View.