Follow
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. 
custom_view_hours_with_task_and_issue_information.png

To apply this view:

  1. Navigate to a list of hours.
  2. From the View drop-down menu, select New View.
  3. In the Column Preview area, eliminate all columns except for one.
  4. Click the header of the remaining column, then 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:
    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
  7. Click Save View.
This article last updated on 2018-06-28 13:28:08 UTC