This functionality shows the time a task has spent in the current status. Since the custom field is part of the built-in Jira functionality, you can manipulate and configure this field like any other in Jira.
Search for the tasks with a specific custom field (this means you should search for the tasks from the project in which time tracking is currently occurring in the chosen status).
JQL: “<Custom Field name>” is not empty
...
2. Search for the tasks where the time value is about 80 days.
JQL: "<Custom Field name>" ~ "80d"
...
That’s all!To use Time in Status custom fields in Jira Query Language (JQL), follow these steps:
Open advanced search: Click the search bar in Jira. Then, Select "Advanced search".
Write the JQL query: In the JQL search bar, enter one of the following queries using the name of your custom field that you create for certain board:
"days:Custom_field_name"to search for issues based on the number of days in the current status."hours:Custom_field_name"to search for issues based on the number of hours in the current status."minutes:Custom_field_name"to search for issues based on the number of minutes in the current status.
Execute the search: Once you have written the JQL query, click the "Search" button to execute the search and view the results.
Important Notes:
Use fractional numbers: The custom field Time in Status format is a number and you can use fractional numbers in your JQL query (1.5, 2.3, etc.)
JQL Operators: You can use operators such as ">", "<", "=", ">=", "<=", and "!=" with the Time in Status custom field in JQL
Example of correct JQL : "Custom_field_name" IS NOT EMPTY
Example: Enter "days:TIS [DEV Proj]"> 1.5 in the JQL search bar to search for issues that have been in their current status for more than 1.5 days.
...
| Note |
|---|
If you’ve created custom fields in versions of the Time in Status app before 1.7.45-AC, here’s how to make the most of your JQL search. |
To use the custom field TIS [board_name] in Jira Query Language (JQL), follow these steps:
Open advanced search: Click the search bar in Jira. Then, Select "Advanced search".
Write the JQL query: In the JQL search bar, enter one of the following queries using the custom field TIS [board_name] and its alias "Time in Status":
"days:Time in Status"to search for issues based on the number of days in the current status."hours:Time in Status"to search for issues based on the number of hours in the current status."minutes:Time in Status"to search for issues based on the number of minutes in the current status.
Execute the search: Once you have written the JQL query, click the "Search" button to execute the search and view the results.
Important Notes:
Use fractional numbers: The custom field Time in Status format is a number and you can use fractional numbers in your JQL query (1.5, 2.3, etc.)
JQL Operators: You can use operators such as ">", "<", "=", ">=", "<=", and "!=" with the Time in Status custom field in JQL
Example of correct JQL : "TIS [TIS Line Board]" IS NOT EMPTY
Example: Enter “days:Time in Status" > 1.5 in the JQL search bar to search for issues that have been in their current status for more than 1.5 days.
| Info |
|---|
If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net |
| Tip |
|---|
Haven't used this add-on yet? Try it now! >>> |