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 | annualleavelist | alert | alertmessages | alertsummaries | alerttrend | balance | bsi | chart | children | closedtasks | competitorcount | competitors | 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 | scheduling | seqno | sickleave | specialleave | start | status | targets | turnover | 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.
annualleavebalance
The balance of the annual leave at the end of the reporting interval. The unit can be adjusted with loadunit.
annualleavelist
A list with all annual leave intervals. The list can be customized with the listtype attribute.
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 beginning of the report period. Possible values are Up, Down or Flat.
balance
The account balance at the beginning of the reported period. This is the balance before any transactions of the reported period have been credited.
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.
children

A list of all direct sub elements.

The list can be customized by the listitem and listtype attributes.

closedtasks
The number of sub-tasks (including the current task) that have been closed during the reported time period. Closed means that they have an end date before the current time or now date.
competitorcount
The number of tasks that have successfully competed for the same resources and have potentially delayed the completion of this task.
competitors
A list of tasks that have successfully competed for the same resources and have potentially delayed the completion of this task.
complete
The completion degree of a task. Unless a completion degree is manually provided, this is a computed value relative to 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 tasks the computation degree is the percentage of done effort of the overall effort. For other leaf tasks, the completion degree is the percentage of the already passed duration of the overall task duration. For container tasks, 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, or how 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 and listtype 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 and listtype.column attributes. The dependency symbol can be generated via the dependency attribute in the 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. Resources that are marked as unemployed at the report start time are not counted. 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 and listtype attribute.

journal
The journal entries for the task or resource for the reported interval. The generated text can be customized with 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 and listtype attributes.

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 an 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 and listtype attributes. The dependency symbol can be generated via the dependency attribute in the 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 and listtype attributes.

resources

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

The list can be customized by the listitem and listtype attributes.

responsible

The responsible people for this task.

The list can be customized by the listitem and listtype attributes.

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
scheduling
The scheduling mode of the leaf tasks. ASAP tasks are scheduled start to end while ALAP tasks are scheduled end to start.
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.
specialleave
The number of special leave units within the reported time period. The unit can be adjusted with loadunit.
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 and listtype attributes.

turnover
The financial turnover of an account during the reporting interval.
wbs
Deprecated alias for bsi.
unpaidleave
The number of unpaid leave units within the reported time period. The unit can be adjusted with loadunit.
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, 2013, 2014, 2015, 2016, 2017, 2018, 2019, 2020 by Chris Schlaeger <cs@taskjuggler.org>.TaskJuggler is a trademark of Chris Schlaeger.