Report Active Reviews

Report Active Reviews

When to Use

• Listing which API reviews were active during a time period
• Checking which packages were reviewed for a specific language
• Verifying which revisions were approved vs unapproved
• Investigating review activity for a language

Defaults

Unless the user says otherwise, always apply these defaults:

• Environment: production
• Summary: Include --summary for a quick overview (skip if user asks for full details or JSON)
• Approved only: Do NOT pass --approved-only unless the user explicitly asks

Date Resolution

The user will typically specify a calendar month by name (e.g. "March", "January 2025"). Resolve to the full month date range:

| User says | start_date | end_date |

|-----------|-----------|----------|

| "March" (current year) | YYYY-03-01 | YYYY-03-31 |

| "January 2025" | 2025-01-01 | 2025-01-31 |

| "March 1 to March 15" | YYYY-03-01 | YYYY-03-15 |

When only a month name is given without a year, use the current year. Be careful with month lengths (28/29/30/31 days).

Language

The --language flag is optional. If omitted, the command returns results for all languages. When a language is provided, results are filtered to that language only.

Running the Command

Step 1: Run the Command

Show the resolved command and run it immediately in a foreground terminal with a 120-second timeout (timeout: 120000). Always redirect output to a file so follow-up questions can be answered without re-querying.

Full terminal command (cleanup + run):

New-Item -ItemType Directory -Path output -Force | Out-Null; if (Test-Path output/active_reviews_output.txt) { Remove-Item output/active_reviews_output.txt }; python cli.py report active-reviews -s <start_date> -e <end_date> -l <language> --summary 2>&1 | Out-File -Encoding UTF8 output/active_reviews_output.txt

After the command completes, read the output file with read_file to get the results. Summarize the findings for the user.

For JSON mode (no --summary), use .json extension and do NOT use 2>&1:

New-Item -ItemType Directory -Path output -Force | Out-Null; if (Test-Path output/active_reviews_output.json) { Remove-Item output/active_reviews_output.json }; python cli.py report active-reviews -s <start_date> -e <end_date> -l <language> | Out-File -Encoding UTF8 output/active_reviews_output.json

Step 2: Answer Follow-up Questions

For follow-up questions about the same data (filtering, counting, searching), read the output file with read_file instead of re-running the command. The file is at output/active_reviews_output.txt (summary) or output/active_reviews_output.json (JSON).

Examples

# Python reviews for March 2025 (summary)
python cli.py report active-reviews -s 2025-03-01 -e 2025-03-31 -l python --summary

# C# reviews, approved only
python cli.py report active-reviews -s 2025-03-01 -e 2025-03-31 -l dotnet --approved-only --summary

# Full JSON output for Java
python cli.py report active-reviews -s 2025-03-01 -e 2025-03-31 -l java

# Staging environment
python cli.py report active-reviews -s 2025-03-01 -e 2025-03-31 -l python --summary --environment staging

Available Flags

| Flag | Type | Default | Description |

|------|------|---------|-------------|

| --start-date / -s | string | required | Start date (YYYY-MM-DD) |

| --end-date / -e | string | required | End date (YYYY-MM-DD) |

| --language / -l | string | None | Language to filter by (e.g., python, Go, C#). If omitted, returns all languages. |

| --environment | string | production | production or staging |

| --summary | flag | off | Table format instead of JSON (package, version, status, copilot) |

| --approved-only | flag | off | Show only approved revisions |

Output Formats

• Summary mode (--summary): Formatted table with PACKAGE, VERSION, STATUS (APPROVED/unapproved), COPILOT (YES/no), TYPE, APPROVED timestamp.
• JSON mode (default): Array of objects with review_id, name, and revisions list.

Gotchas

• Use python cli.py not .\avc: The avc.bat script may resolve to system Python.
• Month end dates: February has 28/29 days, April/June/Sept/Nov have 30 days.