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