Querying TeamTime data with JQL

You can access TeamTime data in JQL via using the following aliases, depending on the time format you need:


Estimate (TL)

Estimate (TL)

Remaining (TL)

Ratio (TL)

in seconds

estimateInSecondsTL

timeSpentInSecondsTL

remainingInSecondsTL

RatioTL

in minutes

estimateInMinutesTL

timeSpentInMinutesTL

remainingInMinutesTL

in hours

estimateInHoursTL

timeSpentInHoursTL

remainingInHoursTL

in days

estimateInDaysTL

timeSpentInDaysTL

remainingInDaysTL

in weeks

estimateInWeeksTL

timeSpentInWeeksTL

remainingInWeeksTL

By using these aliases together with the logical operators, you can apply more precise filtering to later use it in TeamTime report creation.

Available operators: = , != , > , >= , < , <=, IS , IS NOT, IN , NOT IN

TeamTime takes days-to-week ratio from within your Jira settings . If you have it set up so one week is 7 days, the app will calculate in accordingly.

Dashboards and Gadgets

Good news: you can utilize TeamTime’s data outside of TeamTime, in your Dashboards! To do so, continue using the aliases mentioned above while configuring gadgets.


🔔

Stay informed

Subscribe to get the latest updates and explore new product capabilities

👉 Subscribe for updates