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 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 Statusto search for issues based on the number of days in the current status.hours:Time in Statusto search for issues based on the number of hours in the current status.minutes:Time in Statusto search for issues based on the number of minutes in the current status.
3. 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: 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! >>> |