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:
*To find out what plan, license type, or access you have, contact your Workfront administrator.
View combined task and issue details in an Hour list
To apply this view:
-
Go to a list of hours.
-
From the View drop-down menu, select 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.
-
Mouse over the text mode area, and click Click to edit text.
-
Remove the text you find in the Text Mode box, and replace it with the following code:
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 Save View.