📖 Step by step - Time in status

The time functionality in the status is divided into two parts.

The first is general search functions for which no additional configuration is required. They work right after installing the plugin.

Common

• issue in timeInStatus(“statuses”, “condition”, “time”) - Find tasks that have spent the specified time in statuses.
  • Params:
  • statuses - name or id, Comma separated
• issue in timeInStatusByJql(“jql”, “statuses”, “condition”, “time”) - Find tasks from a jql request that have spent the specified time in statuses.
  • Params:
  • jql - query for filter tasks
  • statuses - name or id, Comma separated
• issue in timeInStatusByJqlAndWorkCalendar(“jql”, “statuses”, “condition”, “time”, “calendar”) - Find tasks from a jql request that spent the specified working time in statuses. Working hours will be calculated according to the specified calendar.
  • Params:
  • jql - query for filter tasks
  • statuses - name or id, Comma separated
  • calendar - work calendar name or id for calculate work time

These functions are presented in user help.

The Jira administrator can customize how these functions work: adjust performance and the number of processed values in real time. You can also configure limited access to these search functions. Performance config JQL

The second part is working with time through the configured “Time in status” fields.

Each field can count how much time the task spent in the specified status or statuses. The statuses are specified in the field settings. Fields store intermediate values in indexes and are faster processed in real-time searches. In the field, you can specify execution contexts, specify additional options for timing, customize the display and access to the value. By the "Time in status" fields, you can also sort tasks, build reports and export them.

• About fields
• More about Time in status field

1. Create a new field “Time in status”, Then set contexts and screens.

• Atlassian Guide: Adding a custom field
• Atlassian Guide: Configuring a custom field

2. After creating the field, go to its settings:

1. 
2. 
3. 

Specify the statuses in which you want to count the time and save the settings. For the search to work, you also need to run the reindx for jira or for the project. Search indexing

After re-indexing, search functions for fields will be available

Search by state

• “field name” in active() - Search by active time in status fields(issue in selected statuses)
• “field name” in inactive() - Search by inactive time in status fields(issue not in selected statuses)

Search by time

• “field name” in time(“condition”, “time”) - Search by time in status fields(by total time in selected statuses)/Timer field. Time value from index.
• “field name” in realTime(“condition”, “time”) - Search by time in status fields(by total time in selected statuses)/Timer field. Time value calculate realtime.

• “field name” in realTimeBetween(“time”, “time”) - Search by realtime in status fields(by total time in selected statuses). Time value calculate realtime.

• Examples:
  • “Time in new” in realTime(“>”, “20m”) AND “First reaction” in realTime(“<”, “1h”)
  • “Time in new” in realTimeBetween(“1h”, “2h”)

These functions are presented in user help.

---

User JQL help

← Previous

📖 How to create Timer and configure it step-by-step

Next →