Using Time in Status Custom Field in JQL

Owned by Mariana Pryshlyak (Unlicensed)
Last updated: Oct 06, 2023 by Nazarii Tsymbrak
1 min read

To use the custom field TIS [board_name] in Jira Query Language (JQL), follow these steps:

  1. Open advanced search: Click the search bar in Jira. Then, Select "Advanced search".

  2. 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.

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.

If you need help or want to ask questions, please contact SaaSJet Support or email us at support@saasjet.atlassian.net

Haven't used this add-on yet? Try it now! >>>