generate-status-report

Generate Status Report Keywords status report, project status, weekly update, daily standup, Jira report, project summary, blockers, progress update, Confluence report, sprint report, project update, publish to Confluence, write to Confluence, post report Automatically query Jira for project status, analyze issues, and generate formatted status reports published to Confluence. CRITICAL : This skill should be interactive . Always clarify scope (time period, audience, Confluence destination) with the user before or after generating the report. Do not silently skip Confluence publishing—always o…

)\n \n if not safe_pattern.match(value):\n raise ValueError(\n f\"Invalid characters in input: '{value}'. \"\n f\"Only alphanumeric characters, spaces, hyphens, underscores, dots, and @ are allowed.\"\n )\n \n # Escape double quotes by doubling them (JQL escaping)\n return value.replace('\"', '\"\"')\n\n\ndef sanitize_jql_list(values: List[str]) -> List[str]:\n \"\"\"\n Sanitize a list of values for use in JQL.\n \n Args:\n values: List of input values to sanitize\n \n Returns:\n List of sanitized values\n \"\"\"\n return [sanitize_jql_value(v) for v in values]\n\n\ndef build_project_query(\n project_key: str,\n statuses: Optional[List[str]] = None,\n exclude_done: bool = True,\n priorities: Optional[List[str]] = None,\n days_back: Optional[int] = None,\n assignee: Optional[str] = None,\n order_by: str = \"priority DESC, updated DESC\"\n) -> str:\n \"\"\"\n Build a JQL query for project status.\n \n Args:\n project_key: The Jira project key\n statuses: List of statuses to include (e.g., [\"To Do\", \"In Progress\"])\n exclude_done: Whether to exclude Done status (default True)\n priorities: List of priorities to include (e.g., [\"Highest\", \"High\"])\n days_back: Number of days to look back for updates (e.g., 7)\n assignee: Specific assignee email or \"EMPTY\" for unassigned\n order_by: JQL order by clause (default: \"priority DESC, updated DESC\")\n \n Returns:\n JQL query string\n \"\"\"\n # Sanitize inputs to prevent JQL injection\n project_key = sanitize_jql_value(project_key)\n conditions = [f'project = \"{project_key}\"']\n \n if statuses:\n statuses = sanitize_jql_list(statuses)\n status_list = '\", \"'.join(statuses)\n conditions.append(f'status IN (\"{status_list}\")')\n elif exclude_done:\n conditions.append('status != Done')\n \n if priorities:\n priorities = sanitize_jql_list(priorities)\n priority_list = '\", \"'.join(priorities)\n conditions.append(f'priority IN (\"{priority_list}\")')\n \n if days_back:\n if not isinstance(days_back, int) or days_back \u003c 0:\n raise ValueError(f\"days_back must be a non-negative integer, got: {days_back}\")\n conditions.append(f'updated >= -{days_back}d')\n \n if assignee:\n if assignee.upper() == \"EMPTY\":\n conditions.append('assignee is EMPTY')\n else:\n assignee = sanitize_jql_value(assignee)\n conditions.append(f'assignee = \"{assignee}\"')\n \n query = \" AND \".join(conditions)\n \n if order_by:\n # Validate order_by contains only safe keywords\n order_by = sanitize_jql_value(order_by)\n query += f' ORDER BY {order_by}'\n \n return query\n\n\ndef build_blocked_query(\n project_key: str,\n high_priority_only: bool = False\n) -> str:\n \"\"\"Build query for blocked issues.\"\"\"\n project_key = sanitize_jql_value(project_key)\n query = f'project = \"{project_key}\" AND status = Blocked'\n \n if high_priority_only:\n query += ' AND priority IN (Highest, High)'\n \n query += ' ORDER BY priority DESC, created ASC'\n return query\n\n\ndef build_completed_query(\n project_key: str,\n days_back: int = 7\n) -> str:\n \"\"\"Build query for recently completed issues.\"\"\"\n project_key = sanitize_jql_value(project_key)\n \n if not isinstance(days_back, int) or days_back \u003c 0:\n raise ValueError(f\"days_back must be a non-negative integer, got: {days_back}\")\n \n return (\n f'project = \"{project_key}\" AND '\n f'status = Done AND '\n f'resolved >= -{days_back}d '\n f'ORDER BY resolved DESC'\n )\n\n\ndef build_in_progress_query(\n project_key: str,\n priorities: Optional[List[str]] = None\n) -> str:\n \"\"\"Build query for in-progress issues.\"\"\"\n project_key = sanitize_jql_value(project_key)\n query = f'project = \"{project_key}\" AND status IN (\"In Progress\", \"In Review\")'\n \n if priorities:\n priorities = sanitize_jql_list(priorities)\n priority_list = '\", \"'.join(priorities)\n query += f' AND priority IN (\"{priority_list}\")'\n \n query += ' ORDER BY priority DESC, updated DESC'\n return query\n\n\ndef build_risk_query(\n project_key: str,\n include_overdue: bool = True\n) -> str:\n \"\"\"Build query for risk items (blocked or overdue high priority).\"\"\"\n project_key = sanitize_jql_value(project_key)\n conditions = [f'project = \"{project_key}\"']\n \n risk_conditions = ['status = Blocked']\n if include_overdue:\n risk_conditions.append('(duedate \u003c now() AND status != Done)')\n \n conditions.append(f'({\" OR \".join(risk_conditions)})')\n conditions.append('priority IN (Highest, High)')\n \n query = \" AND \".join(conditions)\n query += ' ORDER BY priority DESC, duedate ASC'\n return query\n\n\ndef build_unassigned_query(\n project_key: str,\n exclude_done: bool = True\n) -> str:\n \"\"\"Build query for unassigned issues.\"\"\"\n project_key = sanitize_jql_value(project_key)\n query = f'project = \"{project_key}\" AND assignee is EMPTY'\n \n if exclude_done:\n query += ' AND status != Done'\n \n query += ' ORDER BY priority DESC, created ASC'\n return query\n\n\n# Example usage\nif __name__ == \"__main__\":\n # Example queries\n project = \"PROJ\"\n \n print(\"Open Issues Query:\")\n print(build_project_query(project))\n print()\n \n print(\"High Priority In Progress:\")\n print(build_in_progress_query(project, priorities=[\"Highest\", \"High\"]))\n print()\n \n print(\"Blocked Issues:\")\n print(build_blocked_query(project, high_priority_only=True))\n print()\n \n print(\"Completed Last Week:\")\n print(build_completed_query(project, days_back=7))\n print()\n \n print(\"Risk Items:\")\n print(build_risk_query(project))\n print()\n \n print(\"Unassigned Open Issues:\")\n print(build_unassigned_query(project))\n","content_type":"text/x-python; charset=utf-8","language":"python","size":6596,"content_sha256":"7ebf59034972cdf04d73b30f885885d6a6359609778fa584c06759ae03c5f303"}],"content_json":{"type":"doc","content":[{"type":"heading","attrs":{"level":1},"content":[{"text":"Generate Status Report","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Keywords","type":"text"}]},{"type":"paragraph","content":[{"text":"status report, project status, weekly update, daily standup, Jira report, project summary, blockers, progress update, Confluence report, sprint report, project update, publish to Confluence, write to Confluence, post report","type":"text"}]},{"type":"paragraph","content":[{"text":"Automatically query Jira for project status, analyze issues, and generate formatted status reports published to Confluence.","type":"text"}]},{"type":"paragraph","content":[{"text":"CRITICAL","type":"text","marks":[{"type":"strong"}]},{"text":": This skill should be ","type":"text"},{"text":"interactive","type":"text","marks":[{"type":"strong"}]},{"text":". Always clarify scope (time period, audience, Confluence destination) with the user before or after generating the report. Do not silently skip Confluence publishing—always offer it.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Workflow","type":"text"}]},{"type":"paragraph","content":[{"text":"Generating a status report follows these steps:","type":"text"}]},{"type":"ordered_list","attrs":{"order":1,"listStyle":"number"},"content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Identify scope","type":"text","marks":[{"type":"strong"}]},{"text":" - Determine project, time period, and target audience","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Query Jira","type":"text","marks":[{"type":"strong"}]},{"text":" - Fetch relevant issues using JQL queries","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Analyze data","type":"text","marks":[{"type":"strong"}]},{"text":" - Categorize issues and identify key insights","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Format report","type":"text","marks":[{"type":"strong"}]},{"text":" - Structure content based on audience and purpose","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Publish to Confluence","type":"text","marks":[{"type":"strong"}]},{"text":" - Create or update a page with the report","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Step 1: Identify Scope","type":"text"}]},{"type":"paragraph","content":[{"text":"IMPORTANT","type":"text","marks":[{"type":"strong"}]},{"text":": If the user's request is missing key information, ASK before proceeding with queries. Do not assume defaults without confirmation for Confluence publishing.","type":"text"}]},{"type":"paragraph","content":[{"text":"Clarify these details:","type":"text"}]},{"type":"paragraph","content":[{"text":"Project identification:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Which Jira project key? (e.g., \"PROJ\", \"ENG\", \"MKTG\")","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"If the user mentions a project by name but not key, search Jira to find the project key","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Time period:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"If not specified, ask: \"What time period should this report cover? (default: last 7 days)\"","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Options: Weekly (7 days), Daily (24 hours), Sprint-based (2 weeks), Custom period","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Target audience:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"If not specified, ask: \"Who is this report for? (Executives/Delivery Managers, Team-level, or Daily standup)\"","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Executives/Delivery Managers","type":"text","marks":[{"type":"strong"}]},{"text":": High-level summary with key metrics and blockers","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Team-level","type":"text","marks":[{"type":"strong"}]},{"text":": Detailed breakdown with issue-by-issue status","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Daily standup","type":"text","marks":[{"type":"strong"}]},{"text":": Brief update on yesterday/today/blockers","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Report destination:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"ALWAYS ASK","type":"text","marks":[{"type":"strong"}]},{"text":" if not specified: \"Would you like me to publish this report to Confluence? If so, which space should I use?\"","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"If user says yes: Ask for space name or offer to list available spaces","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Determine: New page or update existing page?","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Ask about parent page if creating under a specific section","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Step 2: Query Jira","type":"text"}]},{"type":"paragraph","content":[{"text":"Use the ","type":"text"},{"text":"searchJiraIssuesUsingJql","type":"text","marks":[{"type":"code_inline"}]},{"text":" tool to fetch issues. Build JQL queries based on report needs.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Common Query Patterns","type":"text"}]},{"type":"paragraph","content":[{"text":"For comprehensive queries, use the ","type":"text"},{"text":"scripts/jql_builder.py","type":"text","marks":[{"type":"code_inline"}]},{"text":" utility to programmatically build JQL strings. For quick queries, reference ","type":"text"},{"text":"references/jql-patterns.md","type":"text","marks":[{"type":"code_inline"}]},{"text":" for examples.","type":"text"}]},{"type":"paragraph","content":[{"text":"All open issues in project:","type":"text","marks":[{"type":"strong"}]}]},{"type":"code_block","attrs":{"wrap":false,"language":"jql"},"content":[{"text":"project = \"PROJECT_KEY\" AND status != Done ORDER BY priority DESC, updated DESC","type":"text"}]},{"type":"paragraph","content":[{"text":"Issues updated in last week:","type":"text","marks":[{"type":"strong"}]}]},{"type":"code_block","attrs":{"wrap":false,"language":"jql"},"content":[{"text":"project = \"PROJECT_KEY\" AND updated >= -7d ORDER BY priority DESC","type":"text"}]},{"type":"paragraph","content":[{"text":"High priority and blocked issues:","type":"text","marks":[{"type":"strong"}]}]},{"type":"code_block","attrs":{"wrap":false,"language":"jql"},"content":[{"text":"project = \"PROJECT_KEY\" AND (priority IN (Highest, High) OR status = Blocked) AND status != Done ORDER BY priority DESC","type":"text"}]},{"type":"paragraph","content":[{"text":"Completed in reporting period:","type":"text","marks":[{"type":"strong"}]}]},{"type":"code_block","attrs":{"wrap":false,"language":"jql"},"content":[{"text":"project = \"PROJECT_KEY\" AND status = Done AND resolved >= -7d ORDER BY resolved DESC","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Query Strategy","type":"text"}]},{"type":"paragraph","content":[{"text":"For most reports, execute multiple targeted queries rather than one large query:","type":"text"}]},{"type":"ordered_list","attrs":{"order":1,"listStyle":"number"},"content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Completed issues","type":"text","marks":[{"type":"strong"}]},{"text":": Get recently resolved tickets","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"In-progress issues","type":"text","marks":[{"type":"strong"}]},{"text":": Get active work items","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Blocked issues","type":"text","marks":[{"type":"strong"}]},{"text":": Get blockers requiring attention","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"High priority open","type":"text","marks":[{"type":"strong"}]},{"text":": Get critical upcoming work","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Use ","type":"text"},{"text":"maxResults: 100","type":"text","marks":[{"type":"code_inline"}]},{"text":" for initial queries. If pagination is needed, use ","type":"text"},{"text":"nextPageToken","type":"text","marks":[{"type":"code_inline"}]},{"text":" from results.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Data to Extract","type":"text"}]},{"type":"paragraph","content":[{"text":"For each issue, capture:","type":"text"}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"key","type":"text","marks":[{"type":"code_inline"}]},{"text":" (e.g., \"PROJ-123\")","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"summary","type":"text","marks":[{"type":"code_inline"}]},{"text":" (issue title)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"status","type":"text","marks":[{"type":"code_inline"}]},{"text":" (current state)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"priority","type":"text","marks":[{"type":"code_inline"}]},{"text":" (importance level)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"assignee","type":"text","marks":[{"type":"code_inline"}]},{"text":" (who's working on it)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"created","type":"text","marks":[{"type":"code_inline"}]},{"text":" / ","type":"text"},{"text":"updated","type":"text","marks":[{"type":"code_inline"}]},{"text":" / ","type":"text"},{"text":"resolved","type":"text","marks":[{"type":"code_inline"}]},{"text":" dates","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"description","type":"text","marks":[{"type":"code_inline"}]},{"text":" (if needed for context on blockers)","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Step 3: Analyze Data","type":"text"}]},{"type":"paragraph","content":[{"text":"Process the retrieved issues to identify:","type":"text"}]},{"type":"paragraph","content":[{"text":"Metrics:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Total issues by status (Done, In Progress, Blocked, etc.)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Completion rate (if historical data available)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Number of high priority items","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Unassigned issue count","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Key insights:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Major accomplishments (recently completed high-value items)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Critical blockers (blocked high priority issues)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"At-risk items (overdue or stuck in progress)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Resource bottlenecks (one assignee with many issues)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Categorization:","type":"text","marks":[{"type":"strong"}]},{"text":" Group issues logically:","type":"text"}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"By status (Done, In Progress, Blocked)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"By priority (Highest → Low)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"By assignee or team","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"By component or epic (if relevant)","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Step 4: Format Report","type":"text"}]},{"type":"paragraph","content":[{"text":"Select the appropriate template based on audience. Templates are in ","type":"text"},{"text":"references/report-templates.md","type":"text","marks":[{"type":"code_inline"}]},{"text":".","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"For Executives and Delivery Managers","type":"text"}]},{"type":"paragraph","content":[{"text":"Use ","type":"text"},{"text":"Executive Summary Format","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Brief overall status (🟢 On Track / 🟡 At Risk / 🔴 Blocked)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Key metrics (total, completed, in progress, blocked)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Top 3 highlights (major accomplishments)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Critical blockers with impact","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Upcoming priorities","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Keep it concise","type":"text","marks":[{"type":"strong"}]},{"text":" - 1-2 pages maximum. Focus on what matters to decision-makers.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"For Team-Level Reports","type":"text"}]},{"type":"paragraph","content":[{"text":"Use ","type":"text"},{"text":"Detailed Technical Format","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Completed issues listed with keys","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"In-progress issues with assignee and priority","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Blocked issues with blocker description and action needed","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Risks and dependencies","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Next period priorities","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Include more detail","type":"text","marks":[{"type":"strong"}]},{"text":" - Team needs issue-level visibility.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"For Daily Updates","type":"text"}]},{"type":"paragraph","content":[{"text":"Use ","type":"text"},{"text":"Daily Standup Format","type":"text","marks":[{"type":"strong"}]},{"text":":","type":"text"}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"What was completed yesterday","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"What's planned for today","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Current blockers","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Brief notes","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Keep it brief","type":"text","marks":[{"type":"strong"}]},{"text":" - This is a quick sync, not comprehensive analysis.","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Step 5: Publish to Confluence","type":"text"}]},{"type":"paragraph","content":[{"text":"After generating the report, ALWAYS offer to publish to Confluence","type":"text","marks":[{"type":"strong"}]},{"text":" (unless user explicitly said not to).","type":"text"}]},{"type":"paragraph","content":[{"text":"If user hasn't specified Confluence details yet, ask:","type":"text"}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"\"Would you like me to publish this report to Confluence?\"","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"\"Which Confluence space should I use?\"","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"\"Should this be nested under a specific parent page?\"","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Use the ","type":"text"},{"text":"createConfluencePage","type":"text","marks":[{"type":"code_inline"}]},{"text":" tool to publish the report.","type":"text"}]},{"type":"paragraph","content":[{"text":"Page creation:","type":"text","marks":[{"type":"strong"}]}]},{"type":"code_block","attrs":{"wrap":false,"language":""},"content":[{"text":"createConfluencePage(\n cloudId=\"[obtained from getConfluenceSpaces or URL]\",\n spaceId=\"[numerical space ID]\",\n title=\"[Project Name] - Status Report - [Date]\",\n body=\"[formatted report in Markdown]\",\n contentFormat=\"markdown\",\n parentId=\"[optional - parent page ID if nesting under another page]\"\n)","type":"text"}]},{"type":"paragraph","content":[{"text":"Title format examples:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"\"Project Phoenix - Weekly Status - Dec 3, 2025\"","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"\"Engineering Sprint 23 - Status Report\"","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"\"Q4 Initiatives - Status Update - Week 49\"","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Body formatting:","type":"text","marks":[{"type":"strong"}]},{"text":" Write the report content in Markdown. The tool will convert it to Confluence format. Use:","type":"text"}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Headers (","type":"text"},{"text":"#","type":"text","marks":[{"type":"code_inline"}]},{"text":", ","type":"text"},{"text":"##","type":"text","marks":[{"type":"code_inline"}]},{"text":", ","type":"text"},{"text":"###","type":"text","marks":[{"type":"code_inline"}]},{"text":") for structure","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Bullet points for lists","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Bold (","type":"text"},{"text":"**text**","type":"text","marks":[{"type":"code_inline"}]},{"text":") for emphasis","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Tables for metrics if needed","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Links to Jira issues: ","type":"text"},{"text":"[PROJ-123](https://yourinstance.atlassian.net/browse/PROJ-123)","type":"text","marks":[{"type":"code_inline"}]}]}]}]},{"type":"paragraph","content":[{"text":"Best practices:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Include the report date prominently","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Link directly to relevant Jira issues","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Use consistent naming conventions for recurring reports","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Consider creating under a \"Status Reports\" parent page for organization","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Finding the Right Space","type":"text"}]},{"type":"paragraph","content":[{"text":"If the user doesn't specify a Confluence space:","type":"text"}]},{"type":"ordered_list","attrs":{"order":1,"listStyle":"number"},"content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Use ","type":"text"},{"text":"getConfluenceSpaces","type":"text","marks":[{"type":"code_inline"}]},{"text":" to list available spaces","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Look for spaces related to the project (matching project name or key)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"If unsure, ask the user which space to use","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Default to creating in the most relevant team or project space","type":"text"}]}]}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Updating Existing Reports","type":"text"}]},{"type":"paragraph","content":[{"text":"If updating an existing page instead of creating new:","type":"text"}]},{"type":"ordered_list","attrs":{"order":1,"listStyle":"number"},"content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Get the current page content:","type":"text"}]}]}]},{"type":"code_block","attrs":{"wrap":false,"language":""},"content":[{"text":"getConfluencePage(\n cloudId=\"...\",\n pageId=\"123456\",\n contentFormat=\"markdown\"\n)","type":"text"}]},{"type":"ordered_list","attrs":{"order":2,"listStyle":"number"},"content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Update the page with new content:","type":"text"}]}]}]},{"type":"code_block","attrs":{"wrap":false,"language":""},"content":[{"text":"updateConfluencePage(\n cloudId=\"...\",\n pageId=\"123456\",\n body=\"[updated report content]\",\n contentFormat=\"markdown\",\n versionMessage=\"Updated with latest status - Dec 8, 2025\"\n)","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Complete Example Workflow","type":"text"}]},{"type":"paragraph","content":[{"text":"User request:","type":"text","marks":[{"type":"strong"}]},{"text":" \"Generate a status report for Project Phoenix and publish it to Confluence\"","type":"text"}]},{"type":"paragraph","content":[{"text":"Step 1 - Identify scope:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Project: Phoenix (need to find project key)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Time period: Last week (default)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Audience: Not specified, assume executive level","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Destination: Confluence, need to find appropriate space","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Step 2 - Query Jira:","type":"text","marks":[{"type":"strong"}]}]},{"type":"code_block","attrs":{"wrap":false,"language":"python"},"content":[{"text":"# Find project key first\nsearchJiraIssuesUsingJql(\n cloudId=\"...\",\n jql='project = \"PHOENIX\" OR project = \"PHX\"',\n maxResults=1\n)\n\n# Query completed issues\nsearchJiraIssuesUsingJql(\n cloudId=\"...\",\n jql='project = \"PHX\" AND status = Done AND resolved >= -7d',\n maxResults=50\n)\n\n# Query blocked issues\nsearchJiraIssuesUsingJql(\n cloudId=\"...\",\n jql='project = \"PHX\" AND status = Blocked',\n maxResults=50\n)\n\n# Query in-progress high priority\nsearchJiraIssuesUsingJql(\n cloudId=\"...\",\n jql='project = \"PHX\" AND status IN (\"In Progress\", \"In Review\") AND priority IN (Highest, High)',\n maxResults=50\n)","type":"text"}]},{"type":"paragraph","content":[{"text":"Step 3 - Analyze:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"15 issues completed (metrics)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"3 critical blockers (key insight)","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Major accomplishment: API integration completed (highlight)","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Step 4 - Format:","type":"text","marks":[{"type":"strong"}]},{"text":" Use Executive Summary Format from templates. Create concise report with metrics, highlights, and blockers.","type":"text"}]},{"type":"paragraph","content":[{"text":"Step 5 - Publish:","type":"text","marks":[{"type":"strong"}]}]},{"type":"code_block","attrs":{"wrap":false,"language":"python"},"content":[{"text":"# Find appropriate space\ngetConfluenceSpaces(cloudId=\"...\")\n\n# Create page\ncreateConfluencePage(\n cloudId=\"...\",\n spaceId=\"12345\",\n title=\"Project Phoenix - Weekly Status - Dec 3, 2025\",\n body=\"[formatted markdown report]\",\n contentFormat=\"markdown\"\n)","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Tips for Quality Reports","type":"text"}]},{"type":"paragraph","content":[{"text":"Be data-driven:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Include specific numbers and metrics","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Reference issue keys directly","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Show trends when possible (e.g., \"completed 15 vs 12 last week\")","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Highlight what matters:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Lead with the most important information","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Flag blockers prominently","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Celebrate significant wins","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Make it actionable:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"For blockers, state what action is needed and from whom","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"For risks, provide mitigation options","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"For priorities, be specific about next steps","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Keep it consistent:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Use the same format for recurring reports","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Maintain predictable structure","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Include comparable metrics week-over-week","type":"text"}]}]}]},{"type":"paragraph","content":[{"text":"Provide context:","type":"text","marks":[{"type":"strong"}]}]},{"type":"bullet_list","content":[{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Link to Jira for details","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Explain the impact of blockers","type":"text"}]}]},{"type":"list_item","content":[{"type":"paragraph","content":[{"text":"Connect work to business objectives when possible","type":"text"}]}]}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Resources","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"scripts/jql_builder.py","type":"text"}]},{"type":"paragraph","content":[{"text":"Python utility for programmatically building JQL queries. Use this when you need to construct complex or dynamic queries. Import and use the helper functions rather than manually concatenating JQL strings.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"references/jql-patterns.md","type":"text"}]},{"type":"paragraph","content":[{"text":"Quick reference of common JQL query patterns for status reports. Use this for standard queries or as a starting point for custom queries.","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"references/report-templates.md","type":"text"}]},{"type":"heading","attrs":{"level":2},"content":[{"text":"Detailed templates for different report types and audiences. Reference this to select the appropriate format and structure for your report.","type":"text"}]}]},"metadata":{"date":"2026-06-05","name":"generate-status-report","author":"@skillopedia","source":{"stars":1331,"repo_name":"plugins","origin_url":"https://github.com/openai/plugins/blob/HEAD/plugins/atlassian-rovo/skills/generate-status-report/SKILL.md","repo_owner":"openai","body_sha256":"9bfdb9a9de6e11b82a87907a54e5ebd1d6f2a107588d1bd8340dbbd4f166075d","cluster_key":"19fb91862a78a1a57ef7576f7fcadff8451be500c8fa7479272f118f106aa047","clean_bundle":{"format":"clean-skill-bundle-v1","source":"openai/plugins/plugins/atlassian-rovo/skills/generate-status-report/SKILL.md","attachments":[{"id":"471ca267-18d6-51d5-9aac-78b9d760c4d7","key":"uploads/10433ee7-ad12-4ae0-b34e-97553e46c6c8/471ca267-18d6-51d5-9aac-78b9d760c4d7/attachment.yaml","path":"agents/openai.yaml","size":115,"sha256":"80a86dad005174e2cc58fe20a032d667a7b80739d5450f571487cb00d7865149","contentType":"application/yaml; charset=utf-8"},{"id":"12040afa-57e6-583e-ab17-df2c46cb8634","key":"uploads/10433ee7-ad12-4ae0-b34e-97553e46c6c8/12040afa-57e6-583e-ab17-df2c46cb8634/attachment.md","path":"references/jql-patterns.md","size":1780,"sha256":"bac0cc8f2cff9cbff8a715f4900803968b5984a33086f612ee788a05a8e9f649","contentType":"text/markdown; charset=utf-8"},{"id":"501c30f4-865b-5fab-b537-1862e8ef9bf9","key":"uploads/10433ee7-ad12-4ae0-b34e-97553e46c6c8/501c30f4-865b-5fab-b537-1862e8ef9bf9/attachment.md","path":"references/report-templates.md","size":2556,"sha256":"618ac02868d47504db18147543b69577105a47bc3dff7116fa5067f3a6b21cf1","contentType":"text/markdown; charset=utf-8"},{"id":"995f3cc5-e667-59e0-865e-3c7829e6caf0","key":"uploads/10433ee7-ad12-4ae0-b34e-97553e46c6c8/995f3cc5-e667-59e0-865e-3c7829e6caf0/attachment.py","path":"scripts/jql_builder.py","size":6596,"sha256":"7ebf59034972cdf04d73b30f885885d6a6359609778fa584c06759ae03c5f303","contentType":"text/x-python; charset=utf-8"}],"bundle_sha256":"61a27ed6d2a9f7ad88a68e12df1161e9cf4972ab856ba42b00493ab13f4b99f3","attachment_count":4,"text_attachments":4,"attachment_storage":"skillopedia-attachments-v1","binary_attachments":0,"excluded_attachments":[]},"cluster_size":2,"skill_md_path":"plugins/atlassian-rovo/skills/generate-status-report/SKILL.md","import_metadata":{"date":"2026-06-05","author":"@skillopedia","version":"v1","category":"integrations-apis","category_label":"Integrations"},"exact_dupes_collapsed_into_this":1},"version":"v1","category":"integrations-apis","import_tag":"clean-skills-v1","description":"Generate project status reports from Jira issues and publish to Confluence. When an agent needs to: (1) Create a status report for a project, (2) Summarize project progress or updates, (3) Generate weekly/daily reports from Jira, (4) Publish status summaries to Confluence, or (5) Analyze project blockers and completion. Queries Jira issues, categorizes by status/priority, and creates formatted reports for delivery managers and executives."}},"renderedAt":1782980959403}

Important: agents should read /llm.txt, /llms.txt, or /.well-known/skills.json to discover the public Skillopedia API.