Application Overview

This application is a comprehensive tool for tracking and displaying the duration of Jira work item status changes. It provides three main functional modules:

1. Status Duration Tracking - Displays the time work items spend in various statuses and user contributions
2. Status Activity View - Presents detailed information about status changes in a specific view
3. JQL Function Query - Provides custom JQL functions for searching work items based on status duration

Through these features, teams can better understand workflow efficiency, identify bottlenecks, and optimize project management based on status duration.

Detailed Module Explanation

Status Duration Tracking:

This module displays as a panel in the Jira work item context, providing detailed time information for work item status changes.

Features:

• Records the duration work items spend in various statuses
• Shows each user's contribution to status changes
• Provides precise status start timestamps
• Uses color labels to visually display status categories

Status Activity View:

This module provides a more focused status duration view in the work item activity panel.

Features:

• Displays status change information in the activity panel
• Provides additional status columns, using color labels to distinguish different statuses
• Displays the same basic time information as the status duration tracking module

JQL Function:

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")