The TaskJuggler User Manual

Project Management beyond Gantt Chart Drawing


<< chargeset << Table Of Contents >> columns >>


Keyword columnid

Purpose
This is a comprehensive list of all pre-defined columns. In addition to the listed IDs all user defined attributes can be used as column IDs.
Syntax (activetasks | annualleave | annualleavebalance | alert | alertmessages | alertsummaries | alerttrend | balance | bsi | chart | closedtasks | complete | completed | criticalness | cost | daily | directreports | duration | duties | efficiency | effort | effortdone | effortleft | email | end | flags | followers | freetime | freework | fte | gauge | headcount | hierarchindex | hourly | id | index | inputs | journal | journal_sub | journalmessages | journalsummaries | line | managers | maxend | maxstart | minend | minstart | monthly | no | name | note | opentasks | pathcriticalness | precursors | priority | quarterly | rate | reports | resources | responsible | revenue | scenario | seqno | sickleave | specialleave | start | status | targets | wbs | unpaidleave | weekly | yearly)
Arguments activetasks
The number of sub-tasks (including the current task) that are active in the reported time period. Active means that they are ongoing at the current time or now date.
annualleave
The number of annual leave units within the reported time period. The unit can be adjusted with loadunit.report.
annualleavebalance
The balance of the annual leave at the end of the reporting interval. The unit can be adjusted with loadunit.report.
alert
The alert level of the property that was reported with the date closest to the end date of the report. Container properties that don't have their own alert level reported with a date equal or newer than the alert levels of all their sub properties will get the highest alert level of their direct sub properties.
alertmessages
Deprecated. Please use journal instead
alertsummaries
Deprecated. Please use journal instead
alerttrend
Shows how the alert level at the end of the report period compares to the alert level at the begining of the report period. Possible values are up, down or flat.
balance
The account balance at the beginning of the reported period.
bsi
The hierarchical or work breakdown structure index (i. e. 1.2.3)
chart
A Gantt chart. This column type requires all lines to have the same fixed height. This does not work well with rich text columns in some browsers. Some show a scrollbar for the compressed table cells, others don't. It is recommended, that you don't use rich text columns in conjuction with the chart column.
closedtasks
The number of sub-tasks (including the current task) that have been closed during the reported time period. Closed means that they have and end date before the current time or now date.
complete
The completion degree of a task. Unless a completion degree is manually provided, this is a computed value relative the now date of the project. A task that has ended before the now date is always 100% complete. A task that starts at or after the now date is always 0%. For effort based task the computation degree is the percentage of done effort of the overall effort. For other leaf task, the completion degree is the percentage of the already passed duration of the overall task duration. For container task, it's always the average of the direct sub tasks. If the sub tasks consist of a mixture of effort and non-effort tasks, the completion value is only of limited value.
completed
Deprecated alias for complete
criticalness
A measure for how much effort the resource is allocated for, orhow strained the allocated resources of a task are
cost
The cost of the task or resource. The use of this column requires that a cost account has been set for the report using the balance attribute.
daily
A group of columns with one column for each day
directreports

The resources that have this resource assigned as manager.

The list can be customized by the listitem attribute.

duration
The duration of a task
duties
List of tasks that the resource is allocated to
efficiency
Measure for how efficient a resource can perform tasks
effort
The allocated effort during the reporting period
effortdone
The already completed effort as of now
effortleft
The remaining allocated effort as of now
email
The email address of a resource
end
The end date of a task
flags
List of attached flags
followers

A list of tasks that depend on the current task. The list contains the names, the IDs, the date and the type of dependency. For the type the following symbols are used for <dep>.

  • ]->[: End-to-Start dependency
  • [->[: Start-to-Start dependency
  • ]->]: End-to-End dependency
  • [->]: Start-to-End dependency

The list can be customized by the listitem attribute. The dependency symbol can be generated via the dependency attribute inthe query, the target date via the date attribute.

freetime
The amount of unallocated work time of a resource during the reporting period.
freework
The amount of unallocated work capacity of a resource during the reporting period. This is the product of unallocated work time times the efficiency of the resource.
fte
The Full-Time-Equivalent of a resource or group. This is the ratio of the resource working time and the global working time. Working time is defined by working hours and leaves. The FTE value can vary over time and is calculated for the report interval or the user specified interval.
gauge
When complete values have been provided to capture the actual progress on tasks, the gauge column will list whether the task is ahead of, behind or on schedule.
headcount

For resources this is the headcount number of the resource or resource group. For a single resource this is the efficiency rounded to the next integer. For a group it is the sum of the sub resources headcount.

For tasks it's the number of different resources allocated to the task during the report interval. Resources are weighted with their rounded efficiencies.

hierarchindex
Deprecated alias for bsi
hourly
A group of columns with one column for each hour
id
The id of the item
index
The index of the item based on the nesting hierachy
inputs

A list of milestones that are a prerequiste for the current task. For container tasks it will also include the inputs of the child tasks. Inputs may not have any predecessors.

The list can be customized by the listitem attribute.

journal
The journal entries for the task or resource for the reported interval. The generated text can be customized with the journalmode, journalattributes, hidejournalentry and sortjournalentries. If used in queries without a property context, the journal for the complete project is generated.
journal_sub
Deprecated. Please use journal instead
journalmessages
Deprecated. Please use journal instead
journalsummaries
Deprecated. Please use journal instead
line
The line number in the report
managers

A list of managers that the resource reports to.

The list can be customized by the listitem attribute.

maxend
The latest allowed end of a task
maxstart
The lastest allowed start of a task
minend
The earliest allowed end of a task
minstart
The earliest allowed start of a task
monthly
A group of columns with one column for each month
no
The object line number in the report (Cannot be used for sorting!)
name
The name or description of the item
note
The note attached to a task
opentasks
The number of sub-tasks (including the current task) that have not yet been closed during the reported time period. Closed means that they have and end date before the current time or now date.
pathcriticalness
The criticalness of the task with respect to all the paths that it is a part of.
precursors

A list of tasks the current task depends on. The list contains the names, the IDs, the date and the type of dependency. For the type the following symbols are used

  • ]->[: End-to-Start dependency
  • [->[: Start-to-Start dependency
  • ]->]: End-to-End dependency
  • [->]: Start-to-End dependency

The list can be customized by the listitem attribute. The dependency symbol can be generated via the dependency attribute inthe query, the target date via the date attribute.

priority
The priority of a task
quarterly
A group of columns with one column for each quarter
rate
The daily cost of a resource.
reports

All resources that have this resource assigned as a direct or indirect manager.

The list can be customized by the listitem attribute.

resources

A list of resources that are assigned to the task in the report time frame.

The list can be customized by the listitem attribute.

responsible

The responsible people for this task.

The list can be customized by the listitem attribute.

revenue
The revenue of the task or resource. The use of this column requires that a revenue account has been set for the report using the balance attribute.
scenario
The name of the scenario
seqno
The index of the item based on the declaration order
sickleave
The number of sick leave units within the reported time period. The unit can be adjusted with loadunit.report.
specialleave
The number of special leave units within the reported time period. The unit can be adjusted with loadunit.report.
start
The start date of the task
status
The status of a task. It is determined based on the current date or the date specified by now.
targets

A list of milestones that depend on the current task. For container tasks it will also include the targets of the child tasks. Targets may not have any follower tasks.

The list can be customized by the listitem attribute.

wbs
Deprecated alias for bsi.
unpaidleave
The number of unpaid leave units within the reported time period. The unit can be adjusted with loadunit.report.
weekly
A group of columns with one column for each week
yearly
A group of columns with one column for each year
Context Global scope



<< chargeset << Table Of Contents >> columns >>


Copyright (c) 2006, 2007, 2008, 2009, 2010, 2011, 2012 by Chris Schlaeger <chris@linux.com>.TaskJuggler is a trademark of Chris Schlaeger.