You should be able to pull the list of work items that are flagged using the issue or issue_custom_fields tables from the Jira product schema.
How long they were flagged may take a bit more work, but should be possible using the Issue History table to query the time the field changed and comparing it against the issue creation time.
Hope thie helps!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Only flagging Jira is not sufficient to track the blocker in better way, we've identified these pain areas of the user and created appDaily Standup Governance for Jirawhich can eliminate to track blocker manually. also you can govern your sprints in better way.
Key Capabilities include:
Jira-Aware Suggestions: Auto-pulls yesterday's activity from status changes, work logs, and comments
Blocker Tracking: Declare blockers with severity levels; facilitators can track and resolve
Anonymous Mood Tracking: Optional team health signals without exposing individuals
Immutable History: All submissions are timestamped and auditable
Give it a try and lets discuss if this better way to manage your blockers for team.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.