Page History

...

The application provides a powerful custom JQL function issueStatusTime for querying work items based on status duration.

Function Syntax:

issueStatusTime("Status Name", "Time Operator", "Duration", "Username(optional)")

Parameter Description:

• Status Name: The status to query (such as "In Progress", "To Do", etc.)
• Time Operator: Supports six operators: =, >=, >, <=, <, !=
• Duration: Format is a combination of "Xd Yh Zm" (X days Y hours Z minutes), such as "2d 4h 30m"
• Username: Optional parameter for limiting to a specific user

Usage Examples:

Find work items that have stayed in "In Progress" status for more than 2 days:

issueStatusTime("In Progress", ">=", "2d")

Find work items processed by "johndoe" and in "To Do" status for less than 1 hour:

issueStatusTime("To Do", "<", "1h", "johndoe")