/
Using Time in Status Custom Field in JQL

Using Time in Status Custom Field in JQL

Owned by Mariana Pryshlyak (Unlicensed)
Last updated: Dec 23, 2024 by Iryna Komarnitska
2 min read

To use Time in Status custom fields 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 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.

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

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:

  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.

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