Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

Tip

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