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“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.
...
| Tip |
|---|
Haven't used this add-on yet? Try it now! >>> |